I have a db table that stores "events". What i want to do is display the next 3 upcoming events, with the event which is next to occur to be the first in the list.
Here is the sql I have at present:
SELECT art_id, art_title, art_date
WHERE art_type =1 AND archived = 0 AND art_date >= "the current date"
ORDER BY art_date DESC limit 3
I am not sure that this is going to give me exactly what I want.