If statement help, please

Ivains

I am trying to add an if statement, but not sure if I am doing it right. I know I not sure. What I want it to do is when the display comes back and the vehicle is in the "In Serv" status I would like it to display it with a green font and if it is "In Shop" I would like it to display it with red font. Right now it just displays it in default black font. I am not sure where to add the statement. Script below:

$sql = "
SELECT *
from $table_name
where $table_name.org = \"$org\"
";

$result = @($sql,$connection) or die("Couldn't execute query.");

}

$the_unit = "

<table width=\"95%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td><center> 
$org Golf Cart / LSV's
</center></td>
</tr>
<tr>
<td align=\"right\"><a href=\"view_unitinspections.php?org=$org\">View Unit Carts Inspection Dates</a> </td>
</tr>
</table>

<tr>

<td bgcolor=#800000>Registration:</td>

<td bgcolor=#800000>Serial Number:</td>

<td bgcolor=#800000>Office Stmbol:</td>

<td bgcolor=#800000>Maint:</td>

<td bgcolor=#800000>Mileage:</td>

<td bgcolor=#800000>Waiver:</td>

<td bgcolor=#800000>Status:</td>

</tr>

while ($row = mysql_fetch_array($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'];

$status = $row['status'];

$the_unit .= "<tr>

<td bgcolor=#808080>$offsym</td>

if($status = In Serv)
{
<td bgcolor=\"#808080\"><center>$status</center></td>
}
";
}

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

sarahk

ok, first things first. here is how to set up a style

<html>
<body>
<style>
body{
	font-family : Arial, Helvetica, sans-serif;
	font-size : 1;
	color : #ffffff;
}
table{
	background-color : #808080;
}
.highlight {
	color : #04A40F;
}</style>
<p>I'm white on white so you won't see me
<table><tr><td>see me</td><td class='highlight'>see me now</td></table>
</body>
</html>

So you will see that the html part of your table can be MUCH simpler. Then just before building the_unit have

$classText = ($status == "In Shop" ? " class='highlight' ": "");

and while building the_unit have

<td $classText>$sn</td>

and finally check out bradsoft.com and richinstyle.com to find out more about classes. They will make your code sooo much simpler.

sarahk

A wee debugging hint for the type of work you are doing. From your browser, choose to view the source and look at the html. Even paste it back into an editor like dreamweaver or golive and see if what you sent makes sense. If not, review your code and find where the problem is.

Good luck.