Forums

This topic is locked

How to select only if dates > today (php/mysql)

Posted 11 Apr 2003 16:20:52
1
has voted
11 Apr 2003 16:20:52 chris chris posted:
I am working with a strange database that has the date stored in three fields.
Day, Month, Year. Month is also the long form like January.

I need to do a select only on records > = todays date.

How do I do this?

thx

Replies

Replied 11 Apr 2003 18:40:58
11 Apr 2003 18:40:58 Brent Colflesh replied:
Take a look here:

www.php.net/manual/en/function.strtotime.php

Regards,
Brent

Replied 13 Apr 2003 01:06:22
13 Apr 2003 01:06:22 chris chris replied:
But how does strtotime help me on the mysql side of things? I can't use strtotime in my select statement, can I?

Reply to this topic