BetterPHP

I can't get around how to do this in my head. I am creating a website where events can be added. I am wanting to display the upcoming events, however I am thinking of this scenario. I have events in the table which have already gone, however using the 'ORDER BY `date`' would show the events that have past still. How would I be able to do this? Would I need to use NOW() and convert the date to a time stamp?

Thanks,
Joe.

You could always have a 'past_event' and whenever the end time of the date has passed, change it to a 1 with a CRON job, then when you are displaying upcoming events, just add AND past_event = 0 to your mysql query.

You will need to do some date calculation and I'm not sure if MySQL is capable of doing so with the DATETIME data type. When using a UNIX TIMESTAMP it's easier to do as you can just add something like

WHERE 'timestamp` > UNIX_TIMESTAMP(NOW())

UNIX_TIMESTAMP(NOW())

can just be

UNIX_TIMESTAMP()

Thanks. I had an idea of how to use, because I had a similar scenario to this in my coursework for A level ICT. That was using Microsoft Access though Think it was something like <date() or something in that case. I just didn't know how to do it in SQL.
Thanks for your time.