Different colors with mysql_fetch_array

[Anon]

Hi,
In my first experiments I have used something like this:

printf("<tr><td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</td>
<td><font face=Verdana size=2 color=#000066>%s</tr>\n", $myrow["a"], $myrow["b"], $myrow["c"], $myrow["d"], $myrow["title"], $myrow["e"]);

} while ($myrow = mysql_fetch_array($result));

What I would like, is that when $myrow["a"] has a particular value, the font color is different. Hope someone can help me out...

[Anon]

you need an array to define your colors

$customColor['mickey'] = '#FFFFFF';
$customColor['minney'] = '#FFccFF';
$customColor['goofy'] = '#FFFFcc';
$customColor['spiderman'] = '#ccFFFF';

then just include

echo '<font color="' . $customColor[$myrow['a']] . '">';

if $myrow['a'] = any of those characters, the color will change accordingly.

Sam Fullman