[SOLVED] Compare php date with mysql date

[fry2010]

I need to compare todays date with a mysql date that is already in a table.

 

So :

 

if( todays_date_in_php > expire_date_set_in_table)

return true;

 

The mysql date is set as '0000-00-00' format, but I cant work out how to convert that to php format and compare them. any pointers or solutions appreciated.

[premiso]

Why not compare it in mysql?

 

You can use strtotime to convert the date in mysql to unix timestamp and compare it, alternatively you can use date to format the date to mysql format date('Y-m-d')

 

 

[fry2010]

thanks a lot. I didnt think of maybe reversing it, but that seems easier. Im not very familiar with date stuff, its the one thing that really elludes me.

[premiso]

Yea, it is confusing. However, the problem with unix timestamps is that they have a limitation of 2038, vs the mysql datetime does not.

 

Just so you know, if trying to go past that date you will get issues using time stamps.

[fry2010]

cool, noted. Thanks again. Works like a charm.