[SOLVED] date (help please)

[phpretard]

I am setting a date in my DB with $current_day=date('m-d-Y');

 

I am looking for a way to check for that day or after and execute code accordingly.

 

The code below does exactly what it should...but I need to somehow say "if $current_day or later"

 

if ($row['enddate']=="$current_day"){ << Problem If Statement
$loginMessage="<tr height=30><td colspan='2'><img src='images/exclaim.gif' border='0'> Your 30 Day Trial Period  Expired ".$row['enddate']."</td></tr>";
}

 

Thank you!

[Mchl]

How is the date stored in database (what data type)?

 

echo $row['enddate']; to display actual format returned from database.

[phpretard]

varchar(10) // Probably Wrong I know

 

echo $row['enddate']; = 12-15-2008

[Maq]

if (strtotime($row['enddate'])==strtotime($current_day)) {

[Mchl]

varchar(10) // Probably Wrong I know

 

echo $row['enddate']; = 12-15-2008

 

Extremely wrong. You will have nothing but trouble with that. Use DATE instead. It will require some changes in your script, but you will be spared a lot of work later.

[9three]

Right now your code says:

 

if CURRENT DATE EQUALS to TODAY then

{

Execute commands

}

 

What you want is:

 

if ($row['enddate'] >= "$current_day"){ //enddate is greater than current day
$loginMessage="<tr height=30><td colspan='2'><img src='images/exclaim.gif' border='0'> Your 30 Day Trial Period  Expired ".$row['enddate']."</td></tr>";
}

[Mchl]

Pardon me, but I believe it will be the other way round. We want to check if expiration date has already passed.

[Maq]

Pardon me, but I believe it will be the other way round. We want to check if expiration date has already passed.

 

Mchl is right.  It should be:

 

if ($row['enddate'] 

[Mchl]

Or, if the date was stored as DATE

 

$query = "SELECT IF('enddate'<=NOW(),1,0) AS expired FROM table WHERE ....";