IF statement assistance

Ivains

Hi Everyone,

I am having a little trouble here with an if statement and was wondering if someone can assist me or point me in the right direction, please.

What I am trying to due is have the $nextdue date display in red if it is <= today's date and display green if it is > today's date.

Here is my sql:

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv, insp
WHERE lsv.org = \"$org\"
AND (lsv.vid = insp.vid)
ORDER BY insp.qrtrly
";

Now here is part of the rest:

$i=0;
while ($row = mysql_fetch_array($sql_result)) {

$vid = $row['vid'];
$reg = $row['reg'];
$sn = $row['sn'];
$org = $row['org'];
$offsym = $row['offsym'];
$vco_n = $row['vco_n'];
$vco_e = $row['vco_e'];
$qrtrly = $row['qrtrly'];
$nextdue = $row['nextdue'];
$nextdue=date('d M Y',strtotime($nextdue));
$status = $row['status'];

if ($row['nextdue'] >= "$today") {
"$nextdue";
} else {
"$nextdue";
}

From what I read from other post it seems this should of worked, but it doesn't. At least the color change, it displays all the nextdue dates fine, but no distinguishment between which is overdue or not.

Any assistance, or other preferred method, or location of a 101 tutorial would be gratefully appreciated.

Thanks
🙂 Ivan

hand

while ($row = mysql_fetch_array($sql_result)) { 
   $vid = $row['vid']; 
   $reg = $row['reg']; 
   $sn = $row['sn']; 
   $org = $row['org']; 
   $offsym = $row['offsym']; 
   $vco_n = $row['vco_n']; 
   $vco_e = $row['vco_e']; 
   $qrtrly = $row['qrtrly']; 
   $nextdue = $row['nextdue']; 
   $nextdue=date('d M Y',strtotime($nextdue)); 
   $status = $row['status']; 

   print "today:$doday nextdue:$row[nextdue]<br>\n";
   $col = "red";
   if ($row['nextdue'] >= "$today") {
      $col = "green";
   }
   print "<font color=$col>$nextdue</font>\n"; 
}

Did you forget the print command?
If not, please tell us the content of fields $today and $row['nextdue']

Ivains

This is the entire script:

include("templates/header.tpl");

include("config.inc");

$today = date("l, F j, Y");

$link = mysql_connect ($server, $user, $password);
if (! $link)
{
die ("Couldn't connect to mySQL server");
}
if (!mysql_select_db ($db, $link) )
{
die ("Couldn't open $db: ".mysql_error() );
}

$chk_id = "SELECT org FROM lsv WHERE org = '$org'";
$chk_id_res = @($chk_id,$link) or die("Couldn't execute query.");
$chk_id_num = mysql_num_rows($chk_id_res);

if ($chk_id_num == "0") {

echo "  Sorry, No Records Found!";

include ("templates/footer.tpl");

exit;

} else {

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv, insp
WHERE lsv.org = \"$org\"
AND (lsv.vid = insp.vid)
ORDER BY insp.qrtrly
";

$sql_result = mysql_query($sql,$link) or die ("Couldn't execute Query!");

}

$the_unit = "

<table width=\"90%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td>
 
<center>
<a href=\"view_singleunit.php?org=$org\">$org</a> Golf Cart / LSV's Inspection Dates
 
</center>
</td>
</tr>
</table>

<table width=90% cellpadding=2 cellspacing=2 border=0>
<tr>
<td bgcolor='$nav_header'>Registration:</td>
<td bgcolor='$nav_header'>Serial Number:</td>
<td bgcolor='$nav_header'>Office Stmbol:</td>
<td bgcolor='$nav_header'>Next Due:</td>
<td bgcolor='$nav_header'>Status:</td>
</tr>";

$i=0;
while ($row = mysql_fetch_array($sql_result)) {

if ($row['nextdue'] >= "$today") {
"$nextdue";
} else {
"$nextdue";
}

$RowColor = $i%2?"#FFFFFF":"#F6F0F0";

$the_unit .= "<tr>

<td bgcolor=\"$RowColor\"><a href=\"view_single.php?vid=$vid\">$reg</a></td>
<td bgcolor=\"$RowColor\">$sn</td>
<td bgcolor=\"$RowColor\">$offsym</td>
<td bgcolor=\"$RowColor\">$nextdue</td>
<td bgcolor=\"$RowColor\">$status</td>
";
$i++;
}

$the_unit .= "</tr></table>";

echo "<div><table width=80% cellpadding=0 cellspacing=0 border=0><tr><td>";

echo "There are ";

include ("includes/count_unit_carts.inc");

echo " cart(s) assigned to $org. ";

echo "</td></tr></table></div>";

echo "$the_unit";

mysql_free_result($sql_result);

mysql_close($link);

include ("templates/footer.tpl");

Thanks for your help...

Ivains

Now it returns the nextdue in red, even if it is not overdue. Just a note: I am not sure, but can it be that the nextdue column is a virtual column created in the sql statement? Here is the sniplet:

\coding here\

$sql = "
SELECT *, insp.qrtrly + INTERVAL 90 DAY as nextdue
FROM lsv, insp
WHERE lsv.org = \"$org\"
AND (lsv.vid = insp.vid)
ORDER BY insp.qrtrly
";

\more coding\

$today = date("l, F j, Y");

$i=0;
while ($row = mysql_fetch_array($sql_result)) {

$rowC = "#FF0000";
if ($row['nextdue'] >= "$today") {
$rowC = "#00C000";
}

$RowColor = $i%2?"#FFFFFF":"#F6F0F0";

$the_unit .= "<tr>

<td bgcolor=\"$RowColor\"><a href=\"view_single.php?vid=$vid\">$reg</a></td>
<td bgcolor=\"$RowColor\">$sn</td>
<td bgcolor=\"$RowColor\">$offsym</td>
<td bgcolor=\"$RowColor\">$nextdue</td>
<td bgcolor=\"$RowColor\">$status</td>
";
$i++;
}

$the_unit .= "</tr></table>";

I appreciate any assistance
🙂 Ivan