Database Output

[corruption]

I want to use two columns, with alternating row colors in the output from this sql statement.

<?php

//should get all the brothers that are not on the exec board.
		 $sql = "SELECT email, fname, brother_id, lname FROM brothers WHERE office=\"\" ORDER by lname ASC";
		 $result = mysql_query($sql);
		 if ($result > 0)

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

   echo "<tr>";
   echo "<td><input type=\"checkbox\" value=\"".$row['email']." name=\"".$row['brother_id']." />";
   echo "</td>";
   echo "<td>";
   echo $row['fname']." ".$row['lname'];
   echo "</td>";
   echo "</tr>";
   }
   }

   ?>

[paulnaj]

Here's one way of doing it ... I'd be more inclined to use css class tags, but the principle is the same.

$sql = "
SELECT email, fname, brother_id, lname 
 FROM brothers 
 WHERE office=\"\" 
 ORDER by lname ASC
"; 
$result = mysql_query($sql); 
if ($result > 0) { 
  $bgcolor = "#000000";
  $color = "#FFFFFF";
  while ($row = mysql_fetch_array($result)){ 
      if($bgcolor == "#000000"){
        $bgcolor = "#FFFFFF";
        $color = "#000000";
      } else {
        $bgcolor = "#000000";
        $color = "#FFFFFF";
      } 
       echo "<tr>"; 
       echo "<td bgcolor=\"".$bgcolor."\" color=\"".$color ."\"><input type=\"checkbox\" value=\"".$row['email']." name=\"".$row['brother_id']." />"; 
       echo "</td>"; 
       echo "<td bgcolor=\"".$bgcolor."\" color=\"".$color ."\">"; 
       echo $row['fname']." ".$row['lname']; 
       echo "</td>"; 
       echo "</tr>"; 
 } 
}

Paul.

PS. You could save yourself a little typing and a lot of debug time if you use the following quotation style ...

echo '<td bgcolor="'.$bgcolor.'" color="'.$color .'">';

... but this is just my coding style preference!