Hi,
i'm doing an event calendar and i'm having some problems to solve the following problem:
i have a table for the events, and in that table i have the fields date_begin and date_end of the type DATE;
what i'm trying to get is all the months and correspondent year where a event exists.
Ex:
id date_begin date_end
1 2008-12-16 2009-01-17
2 2009-02-16 2009-02-18
3 2009-04-16 2009-05-16
4 2009-05-16 2009-07-16
In this case i need as a result
(12-2008,01-2009,02-2009,04-2009,05-2009,06-2009,07-2009)
i'm using php and mysql db
thx
