Checking date from DB

[coupe-r]

I have a DATETIME column in my DB which stores the date as YYYY/MM/DD.  I want to check to make sure that todays date is not greater than the value in the DB.  This is basically checking their subscription expiration date.

 

Will this work?

 

if($row['sub_exp'] <= date("Y/m/d"))

{

//expiration expired kick them out

}

[ChemicalBliss]

no, the operators are for mathmateical operations, true/false/boolean etc.

 

 

you need to use strtotime(); or onvert your database into timestamps and it would be a million times simpler.

 

 

 

http://php.net/strtotime

 

-cb-

[PFMaBiSmAd]

If the formats on both sides of the comparison are identical (and with two digit month and day values) you can compare dates that way (as long as format has the year is first, followed by the month, then the day.) However, a mysql DATETIME is not that exact format, so what you posted would not work.