MySQL/php date question ~~~ 500pts
Posted on 2004-05-01
Heeey! So wonderful to see you here!
I'm using MySQL & PHP
I want to get the dates from the database, and compare them to the current date using php. (not an SQL query) I'd like to leave the database how it is; i.e. dates formatted as YYYY-MM-DD, and do the conversions in PHP.
So, basically I want to do this: 'if variableDate is more recent than currentDate, do somehthing'
Also, I will want to insert dates back into the database, formatted correctly.
Thanks in advance for your help!