result formatting

[Anon]

Can anyone help me with formatting my results? I would like each result to have a different table color... Like the results in this forum...

Here is the code without any formatting...:

any ideas?:
<?php

// create connection
$connection = mysql_connect("localhost","user","pass")
or die("Couldn't make connection.");

// select database
$db = mysql_select_db("user", $connection)
or die("Couldn't select database.");

// create SQL statement
$sql = "SELECT comments
FROM shows
ORDER BY comments DESC";

// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

// start results formatting
echo "<TABLE BORDER=0>";

//this is the area in question
while ($row = mysql_fetch_array($sql_result)) {

$comments = $row["comments"];
echo "<TR>
<TD><div align=\"center\">$comments</div><hr width=\"80%\" noshade size=\"1\"></TD>
</TR>
";

}

echo "</TABLE>";

// free resources and close connection
mysql_free_result($sql_result);
mysql_close($connection);

?>

Thanks in advance...

[Anon]

//this is the area in question
$i = 0;
while ($row = mysql_fetch_array($sql_result)) {

$i++
if ($i % 2) {
$bgcolor = "RED";
}
else {
$bgcolor = "BLUE";
}

$comments = $row["comments"];
echo "<TR>
<TD bgcolor=\"$bgcolor\"><div align=\"center\">$comments</div><hr width=\"80%\" noshade size=\"1\"></TD>
</TR>
";

[Anon]

Hey Thanks Rob... But I get

Parse error: parse error in /usr/home/v1/a0008044/html/elcentro.inc on line 29

//this is the area in question
$i = 0;
while ($row = mysql_fetch_array($sql_result)) {

$i++
if ($i % 2) { //THIS IS LINE 24//
$bgcolor = "RED";
}
else {
$bgcolor = "BLUE";
}

$comments = $row["comments"];
echo "<TR>
<TD bgcolor=\"$bgcolor\"><div align=\"center\">$comments</div><hr width=\"80%\" noshade size=\"1\"></TD>
</TR>
";

thanks

[Anon]

Hey I tweaked it until I came up with this...
with help from cool people like you!!

$setcolor = 0;
while ($row = mysql_fetch_array($sql_result))
{
if($setcolor == 0)
{
$bgcolor = "#5A647E";
$setcolor = 1;
} else {
$bgcolor = "#747E9C";
$setcolor = 0;
}
$comments = $row["comments"];
echo "<TR>
<TD bgcolor=\"$bgcolor\"><div align=\"center\">$comments</div></TD>
</TR>
";
}

Thanks man....

[Anon]

That's the same solution. The problem with the code I gave you was probably the spaces.

if ($i%2) {

That probably would have worked. It's just a simple math function asking for the remainder of $i / 2, so if the number is even it returns 0 (which equals false to the if statement) otherwise it returns a number (which reads as true).

I'm glad you got it solved.

[Anon]

Thanks for the help !!!!