Returning multiple results from one row [migrated]
- by krock
I have a set of MySQL data similar to the following:
| id | type | start | end |
=============================================
| 1 | event | 2011-11-01 | 2012-01-02 |
| 2 | showing | 2012-11-04 | 2012-11-04 |
| 3 | conference | 2012-12-01 | 2012-12-04 |
| 4 | event | 2012-01-01 | 2012-01-01 |
I want to retrieve events within a certain date range, but I also want to return individual results for each row that has a time span of more than one day. What's the best way to achieve this?
Using PHP is a possibility, but I wanted to avoid doing this because I will need to to take pagination into account, etc.
Any ideas would be greatly appreciated.
