Table Cell BGCOLOR..Pls Help!!

[Anon]

I am using php to display a data in a table.
I have tried access and mysql and they both work perfectly as far as displaying the table and the data goes.

The trouble is i want to format each column/field so that the bgcolor of each cell in the column/field will be dependent on the value of the data displayed. for example if the value of is less than 5 then bgcolor = red, and so on...pls help me as this is urgent!!!

Olu

[shastry]

Hi,
$result=mysql_query("Select One from MyTable");
$numrows = mysql_num_rows($result);

while($row = mysql_fetch_row($result))
{
if($row[0]<5)
{
echo "<TD><font face=\"Times New Roman(greek)\" color=\"blue\" size=1>$row[0]</a></font></TD>";
}
else
{
echo "<TD><font face=\"Times New Roman(greek)\" color=\"red\" size=1>$row[0]</a></font></TD></tr>";
}
}

--Shastry