Wednesday, 28 August 2013

How to select a record with upcoming date and time?

How to select a record with upcoming date and time?

I have this table called events. This table contains event_date and
event_time in separate columns. I'm currently working on a page where it
will show all the upcoming events. How do I query records from the events
table where the date and time are still upcoming? I mean, how do I
calculate or write the query, specifically the where clause, using MySQL?
I'm using PHP and CodeIgniter.
Thanks to everyone who will answer.

No comments:

Post a Comment