even and odd results ?

[Anon]

hey, im trying to get the results from a mysql query into a table (got that part done), now i want every other result row to be a diffrent color so its easier to read. so im thinking what i need to do is have the even results display one table, and the odd results display another.. am i right and how do i do this ? thanks !

[Anon]

you could alternate using a php variable... like this sorta:

$sql = "SELECT * FROM users";
$sql_r = mysql_query($sql);

$alternate = 0;
echo("<table>");
while ($u = mysql_fetch_array($sql_r)) {
if ($alternate == 0) {
echo("<tr bgcolor=\"blue\">");
$alternate = 1;
} else {
echo("<tr bgcolor=\"red\">");
$alternate = 0;
}
echo ("<td>".$u["id"]."</td>");
echo ("<td>".$u["user"]."</td>");
echo ("</tr>");
}
echo ("</table>");

hope that shows up right and you can get the idea.

[daanw]

I'd prefer to use the % and ? operators (check out the documentation on php.net to see what they do):

<table>
<?php
for ($i = 0; $i < 20; $i++) {
$bgcolor = $i % 2 ? "red" : "blue";

    echo "<tr>";
    echo "<td bgcolor=\"$bgcolor\">";
    echo "Alternating colors";
    echo "</td></tr>";

}
?>
</table>