Mysql -related

[Anon]

hello,
how to give differnet colours to alternate rows in a table
database is mysql
like the one in phpbuilder.com-forums -display
regards
Roopa

[khaine]

if you want alternating colors.

<TABLE>
<?php

$color="red"

for ( $number=0; $number<10; $number++ )
{
echo "<TR><TD bgcolor=\"".$color."\">";
echo "line ".$number;
echo "</TD></TR>";

if ( $color == "red" )
{
    $color="blue";
}
else
{
    $color="red";
}

}

?>

</TABLE>

Mark.

[znouza]

<?
$q=mysql_query(...);
$color="white";
while($row=mysql_fetch_row($q))
{
$color=($color=="gray")?"white":"gray";
echo <tr bgcolor=\"$color\">
echo "<td...>";
}

[Anon]

Or simply use the remainder...odd or even...

<TABLE>
<?php
for ($i = 0; $i < 9; $i++) {
if ($i % 2 == 0)
$color = "#404040";
else
$color = "#555555";
echo "<tr bgcolor='$color'><td>blabla</td<";
}
?>
</TABLE>