Change color?

[Anon]

I get the results out of a database with mysql and i put them in a table...but do you know how i can change the color codes so that the color in the table change each row?...

The code:
----------start--------
$result = mysql_query($sql);
print "<table align=center width=800 cellpadding=1 bgcolor=000000 cellspacing=0><tr><td>";
print "<table align=center width=800 cellpadding=1 bgcolor=FFFFFF cellspacing=0>";
while ($a_row=mysql_fetch_array($result))
{
print "<tr><td bgcolor=#c0c0c0> <font face=arial size=2> $a_row[produkt] </font></td>";
print "<td bgcolor=#c0c111> <font face=arial size=2> $a_row[type]</font></td>";
print "<td bgcolor=#c0c111> <font face=arial size=2> $a_row[prijs]</font></td>";
print "<td bgcolor=#c0c0c0> <font face=arial size=2> $a_row[winkel]</font></td></tr>";
}

[Anon]

Start by doing a freakin' search here.

http://phpbuilder.com/forum/read.php3?num=2&id=111462&loc=0&thread=111462

[Anon]

You have the color changing for each column...do you also want it changing for each row??

Look at the article that Tom gave...if that doesn't help then ask some specific questions..

if ($count++ % 2 == 1) { echo "<tr bgcolor=\"#000000\">"; } else { echo "<tr bgcolor=\"#FFFFFF\">"; }

---John Holmes...