Displaying Mysql rows, alternate colors?

Expand Post »

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?

Similar Threads

MySQL SELECT rows In a Date Range in MySQL
Mysql match and return words in field w/ all rows in MySQL
Event Handler in dynamic table rows in JavaScript / DHTML / AJAX
Query multiple tables with duplicate data in MySQL
plz help a table formatting problem in HTML and CSS

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

Permalink

Oct 29th, 2007

Re: Displaying Mysql rows, alternate colors?

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:

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;

Last edited by Rankenian; Oct 29th, 2007 at 6:19 pm.

Rankenian

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Oct 2007

Permalink

Oct 29th, 2007

Re: Displaying Mysql rows, alternate colors?

Thanks, that worked great!

Last edited by nathanpacker; Oct 29th, 2007 at 6:44 pm.

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Problem with inserting data into mysql with PHP

Next Thread in PHP Forum Timeline: Newbie Needs Form Help

DaniWeb Message

Cancel Changes

User Name
Password