Color Blind - Need help!!!

[Anon]

Hi I am trying to get some date from a database and place it on a web page...

The problem I am having is to get PHP to alternate the colors for each line - say light blue, then white, then light blue, then whist again and again, till the end of the list.

here is teh code I have so far:

Thnx,
Charlie

<?PHP

  // Displays info about the number of rows
  // found in the database matching the
  // search

print "The query: '$query' returned $num_of_rows rows of
data.";


  // Displays the table headers

print "
<p>
<table width=715 border=\"1\" cellspacing=\"0\" cellpadding=\"2\">
  <tr> 
    <th nowrap>Account ID</th>
    <th nowrap>Name</th>
    <th nowrap>Address</th>
    <th nowrap>Town</th>
    <th nowrap>State</th>
    <th nowrap>Zip</th>
    <th nowrap>Country</th>
    <th nowrap>Email</th>
    <th nowrap>Phone Number</th>
    <th nowrap>Signup Date</th>
  </tr>
";

  // LOOP - Loops until all rows found in
  // the database matching the search are
  // displayed.

while ($row = mysql_fetch_row ($query_result_handle))
{ 
	print "
  <tr>
    <td nowrap><b>&nbsp;$row[1]&nbsp;</b></td>
    <td nowrap>&nbsp;$row[2]&nbsp;</td>
    <td nowrap>&nbsp;$row[3]&nbsp;</td>
    <td nowrap>&nbsp;$row[4]&nbsp;</td>
    <td nowrap>&nbsp;$row[5]&nbsp;</td>
    <td nowrap>&nbsp;$row[6]&nbsp;</td>
    <td nowrap>&nbsp;$row[7]&nbsp;</td>
    <td nowrap>&nbsp;$row[8]&nbsp;</td>
    <td nowrap>&nbsp;$row[9]&nbsp;</td>
    <td nowrap>&nbsp;$row[10]&nbsp;</td>
  </tr>
"; 
}

  // Closes (Ends) the table tag
print "
</table>
";
?>

[bastien]

$x=1; //set the color tag counter

while ($row = mysql_fetch_row ($query_result_handle))
{
if ($x==1){
echo "<tr bgcolor = \"lightblue\">;
$x=0;
}else{
echo "<tr bgcolor = \"white\">;
$x=1;
}
echo "
<td nowrap> $row[1] </td>
<td nowrap> $row[2] </td>
<td nowrap> $row[3] </td>
<td nowrap> $row[4] </td>
<td nowrap> $row[5] </td>
<td nowrap> $row[6] </td>
<td nowrap> $row[7] </td>
<td nowrap> $row[8] </td>
<td nowrap> $row[9] </td>
<td nowrap> $row[10] </td>
</tr>
";
}

// Closes (Ends) the table tag
print "
</table> ";

hth
bastien

[rrijnders]

...or you could put the word "alternate" in the search box at the top of the forum and pull up dozens of examples posted here weekly...

[theslinky]

Bastien's method is the best (although you can shorten the code a little more and use arrays to store the color names so you can change it quicker later :-)

Anyway, what i wanted to say was that if you are having a cellspacing of more than 0 between cells and you want that cellspacing NOT to be filled with the background color, then apply the bgcolor to the TD tags versus the TR tag.

-sridhar