PHP make MySQL table rows alternate colours

[davestar_delux]

hey I am trying to display a table and make every other row a different colour, the code I am using is something akin to this:

if ($row % 2 == 1){
echo <tr style="background-color:green">
} else {
echo <tr style="background-color:white">
}

but the mod 2 doesn't seem to be working as every row is coming out the same colour. Anyone any ideas?

 

[marc2003]

something like

$x = 1;
while($row = mysql_fetch_assoc($result)) {
  echo '<tr style="background-color:' . $x % 2 == 1 ? 'green' : 'white' . '">';
  //blah blah
  $x++;
}

 

[davestar_delux]

something like

$x = 1;
while($row = mysql_fetch_assoc($result)) {
  echo '<tr style="background-color:' . $x % 2 = 1 ? 'green' : 'white' . '">';
  //blah blah
  $x++;
}

Ah thanks, that should do the trick. I think I tried a one-liner like that but I'm pretty hopeless with all the quotes and stuff.

 

[djkav]

If you want something thats much easier to read I use this method.

toggleColour = false

Loop
If (toggleColour) then colour = "#000" else colour = "#fff"

toggleColour = NOT toggleColour
Loop end

 

[Inquisitor]

Or:

$alt = false;
foreach ($rows as $row)
{
    echo '<tr style="background-color: ' . ($alt = !$alt) ? 'green' : 'white' . '">';
    // ...
    echo '</tr>';
}