DaniWeb Forum Index > Web Development > PHP

Displaying Mysql rows, alternate colors?

Please support our PHP advertiser: 50% off 6 Months Dedicated Server Hosting from 1&1!

•

Join Date: May 2005

Posts: 232

Reputation: nathanpacker is an unknown quantity at this point

Solved Threads: 0

nathanpacker nathanpacker is offline

Offline

Posting Whiz in Training

Displaying Mysql rows, alternate colors?

Oct 29th, 2007

Hey, I'm using a while loop to display all the rows of a table in my database, and wondered if anyone knows how I can make it so the background color of each row alternates between two different colors. I'm using php to call the information, so I can stick some HTML in there if needed, but is this possible?

•

Join Date: Oct 2007

Posts: 4

Reputation: Rankenian is an unknown quantity at this point

Solved Threads: 0

Rankenian

Offline

Newbie Poster

Re: Displaying Mysql rows, alternate colors?

Oct 29th, 2007

It can be done, just store the colour you want in a variable and swap it with a 2nd colour every time you go around the loop

Something like this:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$bg = '#FF0000';
while ($row = mysql_fetch_array($result)) {
  if ($bg == '#FF0000') $bg = 'FFFF00';
  else $bg = '#FF0000';
 $output .= "<tr bgcolor=\"#" . $bg . "\">" . "<td>" . $row['data'] . "</td></tr>"
}
echo $output;
$bg = '#FF0000';
while ($row = mysql_fetch_array($result)) {
  if ($bg == '#FF0000') $bg = 'FFFF00';
  else $bg = '#FF0000';
 $output .= "<tr bgcolor=\"#" . $bg . "\">" . "<td>" . $row['data'] . "</td></tr>"
}
echo $output;