<?php
$dbHost = "localhost";
$dbUser = "shastry";
$dbPwd = "sercret";
$dbLink = mysql_connect($dbHost,$dbUser,$dbPwd);
$dbDB="test";
$dbSelect=mysql_select_db($dbD😎;
$results = mysql_query("SELECT * FROM color",$dbLink);
printf("<table border=1><TR BGCOLOR=\"CYAN\">
<TD><B>B</B></TD>
<TD><B>C</B></TD>
</TR>\n");
while ($data = mysql_fetch_object($results))
{
printf("<TR>
<TD BGCOLOR=\"WHITE\">%s</TD>",$data->b);
if($data->b=="yes")
{
printf("<TD BGCOLOR=\"WHITE\"><font color=red>%s</font></TD>
</TR>\n",$data->c);
}
else
{
printf("<TD BGCOLOR=\"white\"><font color=black>%s</font></TD>
</TR>\n",$data->c);
}
}
printf("</TABLE>\n");
mysql_free_result($results) ;
?>
--Shastry