alternating row colors

[lukeurtnowski]

I made this script to alternate row colors, but when I look at the source, every <td> has a bgcolor 0f white, what am I missing?

for($i = 0; $i < $numofrows; $i++) {
    if($i % 2) {
        $bgcolor = "silver";
    } else {
        $bgcolor = "white";
    }
        while ($result = mysql_fetch_array($query)) {
    print "<tr>";
    print "<TD bgcolor=\"$bgcolor\">".$result['c_name']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['c_city'].", ".$result['c_state']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['c_desc']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['rationale']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['contact_name']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['contact_phone']."</td>";
    print "<TD bgcolor=\"$bgcolor\">".$result['a_date_formatted']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['a_desc']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['a_next']."</TD>";
    print "<TD bgcolor=\"$bgcolor\" ALIGN=CENTER>".$result['priority']."</TD>";
    print "<TD bgcolor=\"$bgcolor\">".$result['medivas']."</td>";
    print "</TR>\n";
            }
        } 

You can see it in action here...(select the MediVas POC at the right)
http://www.lukesplace.com/Padilla/createreport.php
Thanks😕

[Installer]

Try this:

$i = 0;
while ($result = mysql_fetch_array($query)) { 
    if($i++ % 2) { 
        $bgcolor = "silver"; 
    } else { 
        $bgcolor = "white"; 
    } 
    print "<tr bgcolor=\"$bgcolor\">"; 
    print "<TD>".$result['c_name']."</TD>"; 
    print "<TD>".$result['c_city'].", ".$result['c_state']."</TD>"; 
    print "<TD>".$result['c_desc']."</TD>"; 
    print "<TD>".$result['rationale']."</TD>"; 
    print "<TD>".$result['contact_name']."</TD>"; 
    print "<TD>".$result['contact_phone']."</td>"; 
    print "<TD>".$result['a_date_formatted']."</TD>"; 
    print "<TD>".$result['a_desc']."</TD>"; 
    print "<TD>".$result['a_next']."</TD>"; 
    print "<TD ALIGN=CENTER>".$result['priority']."</TD>"; 
    print "<TD>".$result['medivas']."</td>"; 
    print "</TR>\n"; 
}

[lukeurtnowski]

that worked, so both <TD> and <tr.> can have a bgcolor="" attribute? I thought only <TD> had this capability, thanks soo much.