How to fix date variable? date variable in the if statment not working. How to fix date variable to show Tie - if game day = current date and the score is 0-0

<?php
$hs = $row_rsFootball['homeScore'];
$os = $row_rsFootball['oppenentScore'];
$gd = $row_rsFootball['gameDate'];
$cd = date("Y-M-D");
if ($hs > $os AND $gd <= $cd) {
print "<font color='blue'>winning</font>\n";
} else if ($hs < $os) {
print "<font color='red'>loosing</font>\n";
} else if ($hs == $os AND $gd == $cd) {
print "Tie\n";
} // end if
?>

the date in the database is probably set to the format Y-m-d h:i:s

so the Hours minutes seconds will need to be removed so it is in the same format as your using for comparison:

$gd = date("Y-m-d", strtotime($row_rsFootball['gameDate']));

in my datebase gameDate Type is set to "date" -- does the above still apply? -- I Tried the above It Didn't work

just notice something - in my $cd=date("Y-M-D") should it be $cd=date("Y-m-"d) like you have $gd --?

to troubleshoot, i'll need to know the values of all the variables



echo("HS: ".$hs." OS: ".$os." GD: ".$gd." CD".$cd);

HS: 24 OS: 17 GD: 2013-08-31 CD2013-Sep-Thu

HS: 0 OS: 0 GD: 2013-09-05 CD2013-Sep-Thu

yes, both should use the same format.

winning HS: 24 OS: 17 GD: 2013-08-31 CD2013-09-05

Tie HS: 0 OS: 0 GD: 2013-09-05 CD2013-09-05


Yep I think we fix it...... THANK YOU!!!

Ok adding another else If -- } else if ($gd > $cd) {
print $row_rsFootball['countdown'];
}


Side Note: This is what shows from database <?php echo $row_rsFootball['countdown']; ?>

So I tried

$ct = $row_rsFootball['countdown'];
} else if ($gd > $cd) {
print "$ct"
}

So I am confused !


On a FUNNY Note: Last night I ran the code and it showed todays date -- So I was thinking theres no way -- Cause we ran it early that day... -- got to thinking and check out my -- myphp adin info page and the timezone was set to Europe/Berlin so I changed it to America/New_York -- something like 8 hr difference..... Having the right timezone may help when working with date and time fields on your testing server....... So that leed me to another thought my hosting server is 3 hr difference (i think)...... I there a way I can tell?

1) i need to see the full code in context, p,ease send a copy of the page

2) I need to know what al the variable values are, you need to add code to echo all the variables

3) I also need to know what is in the recordset, add the following code to dump the recordset:
<pre><?php var_dump($row_rsFootball); ?></pre>

4) A link where i can see the problem would be very helpful.

<?php
$hs = $row_rsFootball['homeScore'];
$os = $row_rsFootball['oppenentScore'];
$cd = date("Y-m-d");
$gd = date("Y-m-d", strtotime($row_rsFootball['gameDate']));
//$ct = $row_rsFootball['countdown'];
if ($hs > $os AND $gd == $cd) {
print "<font color='blue'>winning</font>\n";
} else if ($hs < $os AND $gd == $cd) {
print "<font color='red'>loosing</font>\n";
} else if ($hs == $os AND $gd <= $cd) {
print "<font color='brown'>Tie</font>\n";
} else if ($hs > $os AND $gd <= $cd) {
print "<font color='blue'>Won</font>\n";
} else if ($hs < $os AND $gd <= $cd) {
print "<font color='red'>Lost</font>\n";
} else if ($gd > $cd) {
print ($row_rsFootball['countdown']);
}
// echo("HS: ".$hs." OS: ".$os." GD: ".$gd." CD: ".$cd);
// end if ?>