need help with formatting and alternate bg color

[rhock]

can someone show me how to display the results of a query with the records in table cells with alternating color backgrounds for the rows ro results? I have several scripts that will do this but I am unable to make it work with the pagination output below...

is there an easy way to do this to this? TIA

// Now we can display results.
$results = mysql_query("SELECT `name` , `address` , `city` , `phone` , `www` ,`subcatid` FROM `bus_list` WHERE 1 AND `category` LIKE '%Dentists%'  ORDER BY name ASC LIMIT $page, $limit");
while ($data = mysql_fetch_array($results))
{
?>
<p><?=$data["name"]?>&nbsp;<?=$data["address"]?> &nbsp;<?=$data["city"]?> &nbsp; <?=$data["phone"]?>&nbsp;<?=$data["www"]?>&nbsp; <?=$data["subcatid"]?></p>
<?
} 

[thorpe]

echo '<table>';
$color = array('#333','#666');
while ($data = mysql_fetch_array($results)) {
  echo '<tr bgcolor="'.$color[$x=!x].'">';
  echo '  <td>'.$data['name'].'</td>';
  echo '  <td>'.$data['address'].'</td>';
  echo '  <td>'.$data['city'].'</td>';
  echo '  <td>'.$data['phone'].'</td>';
  echo '  <td>'.$data['www'].'</td>';
  echo '  <td>'.$data['subcatid'].'</td>';	
}
echo '</table>';

[rhock]

Hey thanks for the time...it seems to want to work but I either get all black (all rows) or no color?

[thorpe]

theres a typo.

echo '<table>';
$color = array('#333','#666');
while ($data = mysql_fetch_array($results)) {
  echo '<tr bgcolor="'.$color[$x = !$x].'">';
  echo '  <td>'.$data['name'].'</td>';
  echo '  <td>'.$data['address'].'</td>';
  echo '  <td>'.$data['city'].'</td>';
  echo '  <td>'.$data['phone'].'</td>';
  echo '  <td>'.$data['www'].'</td>';
  echo '  <td>'.$data['subcatid'].'</td>';
  echo '</tr>';  

}
echo '</table>';

[rhock]

same problem...all the rows are black no alternating can't change color?

[thorpe]

maybe the two shades of grey are just too dark, lets try black and white.

echo '<table>';
$color = array('#fff','#000');
while ($data = mysql_fetch_array($results)) {
  echo '<tr bgcolor="'.$color[$x=!x].'">';
  echo '  <td>'.$data['name'].'</td>';
  echo '  <td>'.$data['address'].'</td>';
  echo '  <td>'.$data['city'].'</td>';
  echo '  <td>'.$data['phone'].'</td>';
  echo '  <td>'.$data['www'].'</td>';
  echo '  <td>'.$data['subcatid'].'</td>';    

}
echo '</table>';

[bradgrafelman]

Erm, you made the same typo again (or copied from the wrong post). Also, you never declared '$x' and it worked when I used full hexadecimal colors ('000000' vs. '000') try this one:

echo '<table>'; 
$color = array('#333333','#666666');
$x = 0;
while ($data = mysql_fetch_array($results)) { 
  echo '<tr bgcolor="'.$color[$x=!$x].'">'; 
  echo '  <td>'.$data['name'].'</td>'; 
  echo '  <td>'.$data['address'].'</td>'; 
  echo '  <td>'.$data['city'].'</td>'; 
  echo '  <td>'.$data['phone'].'</td>'; 
  echo '  <td>'.$data['www'].'</td>'; 
  echo '  <td>'.$data['subcatid'].'</td>';     

} 
echo '</table>';

[bodzan]

...

$color = array('#333333','#666666');
$x = 0;
while ($data = mysql_fetch_array($results)) { 
     $m = $x%2;
     echo "<tr bgcolor=\"".$color[$m]."\">";
     echo '  <td>'.$data['name'].'</td>'; 
     echo '  <td>'.$data['address'].'</td>'; 
     echo '  <td>'.$data['city'].'</td>'; 
     echo '  <td>'.$data['phone'].'</td>'; 
     echo '  <td>'.$data['www'].'</td>'; 
     echo '  <td>'.$data['subcatid'].'</td>'; 
     $x++;
}

[rhock]

I don't see the "resolved" button I am prpbably just overlooking it... looking at/using what you all have provided I was able to get the code from one of my other scripts to work...here is the code:

echo " <table  border=\"0\" cellspacing=\"0\"cellpadding=\"6\">" ;

 $alt_color++;

  $rowcolor = ($alt_color % 2) ? "#99FFCC" : "#ffffff";

  echo "<tr bgcolor=$rowcolor>\n";

$a = 2; 



  if ($a%2 == 0) { 

$bg = "#99FFCC"; 

  } else { 

$bg = "#FFFFFF"; 

  } 

echo '  <td>'.$data['name'].'</td>'; 
  echo '  <td>'.$data['address'].'</td>'; 
  echo '  <td>'.$data['city'].'</td>'; 
  echo '  <td>'.$data['phone'].'</td>'; 
  echo '  <td>'.$data['www'].'</td>'; 
  echo '  <td>'.$data['subcatid'].'</td>'; 
  echo '</tr>';   

} 
echo '</table>';

Thanks again...