Alternating mysql_fetch_assoc() result rows background color with PHP?

  • Thread starter Thread starter Cathy V
  • Start date Start date
C

Cathy V

Guest
Everything else is working fine but row colors are not alternating. Don't know what's wrong with the code. SOS please! Here is my code:
QUERY
$data=mysql_query("SELECT * FROM tablename WHERE condition AND (other condition) ORDER BY `fieldname` ASC");

RESULTS & VARIABLES & LOOPS
$url="/pictures/";
$num=mysql_num_rows($data);
echo "<table width='100%' cellspacing='0' cellpadding='0'>";

while ($row = mysql_fetch_assoc($data))
{
$n= $row["fieldname1"];
$m=$row["fieldname2"];
$o= $row["fieldname3"];
$p= $row["fieldname4"];
$q= $row["fieldname5"];
$r= $row["fieldname6"];





for($i=0;$i<=$num;$i++)
{
echo"<tr bgcolor=";

if($i % 2==0)
{
echo " '#F0F0F0 ' > ";
}
else
{
echo " '#E5E5E5 ' > ";
}
}
echo

"


<td class='td'>$n</td>
<td class='td'>$m</td>
<td class='td'>$o</td>
<td class='td'>$p</td>
<td class='td'>$q</td>
<td class='td'>";
if(strlen($r)<=0)
{
echo" ";
}
else
{
echo"<img src='$url$r'height='20'width='100%'>";
}
echo
"
</td>
</tr>



"
;





}
;
echo"</table>";
 
Back
Top