[Resolved] alternating row color

[chriswheat]

Hello,

I read a tutorail on how to alternate the row color of a mysql result. However it doesnot seem to work. Does anyone know how to fix the code so that it alternates the color?

$sql = mysql_query("SELECT fname, lname, last_login FROM employee order by lname asc");
$result = mysql_fetch_array($sql);
echo "<table width=\"100%\" border=\"0\" cellpadding=\"5\">
  <tr> 
    <td><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\"><strong>Employee 
      Name</strong></font></td>
    <td><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\"><strong>Last 
      Login</strong></font></td>
  </tr>"; 
    $color1 = "#CCFFCC"; 
    $color2 = "#BFD8BC"; 
    $row_count = 0;

while($row=mysql_fetch_array($sql)) {
   $row_color = ($row_count % 2) ? $color1 : $color2; 
      echo "  <tr> 
    <td bgcolor=\"$row_color\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">".$row['lname']."/".$row['fname']."</font></td>
    <td bgcolor=\"$row_color\"><font size=\"2\" face=\"Verdana, Arial, Helvetica, sans-serif\">".$row['last_login']."</font></td>
  </tr>"; 
   }
$row_count++;
echo "</table>";
PHP] 

here is the output:


<table width="100%" border="0" cellpadding="5">
  <tr> 
    <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Employee 
      Name</strong></font></td>
    <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Last 
      Login</strong></font></td>
  </tr> <tr><td bgcolor="#BFD8BC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Wheat/Chris</font></td>
    <td bgcolor="#BFD8BC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">03/01/2004 -- 05:14:36PM</font></td>
  </tr> <tr><td bgcolor="#BFD8BC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Smith/John</font></td>
    <td bgcolor="#BFD8BC"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">03/01/2004 -- 05:14:36PM</font></td>
  </tr></table>

Any Ideas?
Thanks
Chris

[LordShryku]

}
$row_count++;

Pull your $row_count increment inside of the loop...

[cahva]

Easier way would be:

$row_color=($row_color=="#CCFFCC"?"#BFD8BC":"#CCFFCC");

[chriswheat]

Many thanks to all!! I used LordShryku's solution.

Once again thanks
Chris