Alternate row colours

bjblackmore

Hi
I have an array, that prints out a list in a table, and i want the row colors to alternate, does anyone know how to, i have some code, but it either prints all rows 1 color, or all rows the other, they don't alternate.
Current code
$sql="SELECT * FROM table WHERE country='$country'";
$result=db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo 'Sorry No Results';
} else {
while($rs=mysql_fetch_array($result)){
$i = 0; $item; $i++;
if($i%2)
$bgcolor = "#ffffff";
else
$bgcolor = "#ccccff";
echo "<td bgcolor=$bgcolor><font face=$font>$item[1]</font></td>";

Anon

How about something like this.

(Just changed your bgcolor if statement)

$sql="SELECT * FROM table WHERE country='$country'";
$result=db_query($sql);
if (!$result || db_numrows($result) < 1) {
echo 'Sorry No Results';
} else {
while($rs=mysql_fetch_array($result)){
$i = 0; $item; $i++;
if($bgcolor=="#ccccff")
$bgcolor = "#ffffff";
else
$bgcolor = "#ccccff";
echo "<td bgcolor=$bgcolor>$item[1]</td>";

Chris M.

Anon

You have the $i = 0 inside your loop, so it is being reset every time. Move it outside the loop.

As a little aside, I like doing alternate colours like this:

Anon

Damn. Typo. Should read:
<tr bgcolor="<?=++$i%2?'#ffffff':'#ccccff'?>">

:-)

Anon

Just in case the others don't work for you, here's how I alternate colors:

...
Do your mysql query, or whatever. var is your mysql table column.
...

$color = "#eeeeee";

while ($row = mysql_fetch_array($result))
{

$var = $row["var"];

echo "<table bgcolor=\"$color\"><tr><td>$var";

echo "</TD></TR></table>";

if ($color == "#eeeeee") 
{
$color = "#ffffff"; 
}else{ 
$color = "#eeeeee"; 
}

}

Richie.

Web solutions:
http://3628757392/internet/ffa/