[RESOLVED] IF troubles

[jbachris]

I have played with this IF clause for an hour and can't figure it out.

<?
$todaysdate = 'CURDATE() + 0';
if ( $main_match_rs->Fields("match_date") > $todaysdate ) {
?>
this is where the if HTML goes
<?
}
   else {
?>
this is where the else HTML goes
<?
}
?>

No matter what I do it only shows the else clause as is. If I change the > around to a < it only shows the if clause.

[bpat1434]

using single quotes will interpret as a literal string. If CURDATE() is a function to be run by PHP it needs to be unquoted. If it's mySQL, you don't show where you use it 😉

[jbachris]

I unquoted it and I got this error message:

Call to undefined function: curdate()

[khendar]

There is no function called curdate() in PHP. Its a mysql function. You would probably be better off using date()

http://php.mirrors.ilisys.com.au/manual/en/function.date.php

[jbachris]

great, thanks!