How to make Date Condtion?

[saturngod]

I retrive date from MYSQL and check with current date for account expire.
I write

if($today<$expire)
echo "Work";
else
echo "Expire";

$today is today date and $expire is data from MYSQL.But not work.It always show Work.How to make date condition?

Thank

[NightShift58]

What does $today look like?
What does $expire look like?

My guess is that even though - to you - they are just dates, their internal formats are quite different.

[saturngod]

$today=date('Y-M-d');
$expire='2007-12-18' //is from MYSQL

Sorry i not in home so I don't have source code now,I from cyber cafe.I will wirte code detail when I come bake home.

[NightShift58]

That's your problem then...

date("Y-M-d") ==> 2006-Dec-18
date("Y-m-d") ==> 2006-12-18

[saturngod]

function expiredate($id)
{
$query="SELECT id,expire FROM ads WHERE id=".$id;
$result=@mysql_query($query);
while($row=mysql_fetch_array($result))
{
$expiredate=$row[1];
}
$tody=date("Y-m-d");
if ($tody<$expire)
{
return true;
}
else return false;

}

It always return ture.Doesn't not work.

[NightShift58]

(1) Where does $expire come from?
(2) Just to be safe, you probably want to add " LIMIT 1 " to your $query

[balloonbuffoon]

I would compare the dates based on their timestamps, using time() (http://php.net/time) to get the current timestamp, and strtotime() (http://php.net/strtotime/) to convert the time coming from the database:
function expiredate($id) {
$query="SELECT expire FROM ads WHERE id=".$id;
$result=@mysql_query($query);
$expiredate=mysql_result($result,0,"expire");
$tody=time();
if ($tody<strtotime($expire)) {
return true;
}
else return false;
}--Steve

[NightShift58]

The question still remains: where does $expire come from?

I can see $expiredate but I see no other reference to $expire.

Is perhaps the wrong variable being used to compare dates?

I don't think that doing two conversions from date to time will help at all unless the proper variables are being used at the right time.

[saturngod]

Thank all! I can solve it...

[saturngod]

The question still remains: where does $expire come from?

I can see $expiredate but I see no other reference to $expire.

Is perhaps the wrong variable being used to compare dates?

I don't think that doing two conversions from date to time will help at all unless the proper variables are being used at the right time.

$expire .It's my false.It's $expiredate but not work.Now I finish it and thank you all for help.

[lyndon]

Hi, we hve same situation, can you share me your source code on expire date .. please.. thanks

[knowj]

Why dont you just check everything on the SQL side?

MySQL is more than capable of checking if a date is greater than, less than or equal to. You can also check against todays date et...

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html