I am working on a website for a performing arts center. On the home page I want to feature the next event, which I can easily do with…
SELECT * FROM foo WHERE Date >= currentDate ORDER BY Date LIMIT 1
But what I’m having trouble with is the second section where I want to highlight a number of upcoming events. The problem is that I don’t want to repeat any notice for my “featured next event”, I want to skip over it.
I haven’t got my mind around this one yet and my searches have not uncovered anything… any suggestions?