PHP/MySQL dates

[Anon]

I have been using PHP since May of last year and done a lot of neat things, however, for the first time I must now compare a date field with todays date to make an "expiration" feature for something I am building. I am storing to fields in MySQL as a datatype 'date' YYYY-MM-DD, 1 is posted date and one is expiration date. I can convert these to Unix Timestamp if I have to, but I need to do something like:

if($expires > $today)

how can I do this, I have had date issues with ASP and Perl and had no real probs, but I can't find much info on PHP dates and how to work with them...can anyone help me on this one...please...

[factory21]

This kind of thing is easily done in the database with something like:

SELECT * from myTable where expires>CURDATE();

CURDATE() being the MySQL function for the current date...

if you REALLY want to do it in PHP, you can select the expires field from the database with the MySQL function UNIX_TIMESTAMP(expires), and then compare the result with PHP's time() function.

[Anon]

oh, no, if I can do it in the select, that works for me! I will try it, thanks a lot!

[Anon]

thanks again, it worked like a charm...