Forskellig baggrundsfarve på udkast fra mysql

Kode 

<table cellspacing="0">
<?
$conn = mysql_connect("","","");
mysql_select_db("");

$query = ("SELECT * FROM tags");
$result = mysql_query($query);

while($data = mysql_fetch_array($result)) {
if($i==1) { $farve = "#CCCCCC"; $i=0; }else{ $farve = "#0066CC"; $i=1; }
echo'<tr><td style="background-color:'. $farve .';">';
echo $data['nick'];
echo'</td></tr>';
}

mysql_close($conn);
?>
</table>

Kode 

$conn = mysql_connect("","","");
mysql_select_db("");

$query = ("SELECT * FROM tags");
$result = mysql_query($query);

echo "<table>";

while($data = mysql_fetch_array($result)) {

$i++;

if(is_int($i/2)) {
$farve ="#FF0000"; //Rød
} else {
$farve ="#00AA00"; //Grøn
}

echo "
<tr>
<td bgcolor=\\"$farve\\">$data['nick'];</td>
</tr>";

}

echo "</table>";

mysql_close($conn);

Kode 

$color = "#ffffff";
while($r = mysql_fetch_array($query)) {
    echo "<tr><td style=\\"background:$color;\\">".$r['data']."</td></tr>";
    if($color=="#ffffff") $color=#cccccc; else $color=#ffffff;
}