alternating row colors on query generated table?

[LRW]

Is there some way to make a table have alternating colors for rows when
you're generating the table data with a WHILE statement?
You know, row 1 has a gray BG, row 2 is white, row 3 is gray, 4 is white,
etc, for as long as there's data.
Here's what I'm using right now:

$query_RSwho = "SELECT * FROM tbl_indv ORDER BY name ASC";
$RSwho = @mysql_query($q uery_RSwho, $connection) or die("Couldn't query: "
.. mysql_error());
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$names .= "<tr align=left><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who ['email']."</td></tr>";
}
}

So, in that WHILE section, is there a way to alternate bgcolor table cell
tags?
If there's a web site, or something, just point me? =)
Thanks!
Liam

[Sandman]

In article <yvJ2c.497761$I 06.5347103@attb i_s01>,
"LRW" <dr***@NOSPAHMc elticbear.com> wrote:

Is there some way to make a table have alternating colors for rows when
you're generating the table data with a WHILE statement?
You know, row 1 has a gray BG, row 2 is white, row 3 is gray, 4 is white,
etc, for as long as there's data.
Here's what I'm using right now:

$query_RSwho = "SELECT * FROM tbl_indv ORDER BY name ASC";
$RSwho = @mysql_query($q uery_RSwho, $connection) or die("Couldn't query: "
. mysql_error());
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$names .= "<tr align=left><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who ['email']."</td></tr>";
}
}

So, in that WHILE section, is there a way to alternate bgcolor table cell
tags?
If there's a web site, or something, just point me? =)
Thanks!
Liam

I like compact solutions:

while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
$bg = $nr++ % 2 ? "ffffff" : "eeeeee";
print "<tr bgcolor='#$bg'> ....";
}

But as others have said - use stylesheets:

while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
$bg = $nr++ % 2 ? "even" : "odd";
print "<tr class='$bg'>... .";
}

--
Sandman[.net]

[nice.guy.nige]

While the city slept, LRW <dr***@NOSPAHMc elticbear.com> feverishly typed:

Is there some way to make a table have alternating colors for rows
when you're generating the table data with a WHILE statement?
You know, row 1 has a gray BG, row 2 is white, row 3 is gray, 4 is
white, etc, for as long as there's data.

[...]

I've just quickly knocked this up:
http://www.nigenet.org.uk/stuff/phpRowColours.php

Hope that helps.

Cheers,
Nige

--
Nigel Moss.

Email address is not valid. ni***@nigenetDO G.org.uk. Take the dog out!
http://www.nigenet.org.uk | Boycott E$$O!! http://www.stopesso.com
In the land of the blind, the one-eyed man is very, very busy!

[Brandon Blackmoor]

LRW <dr***@NOSPAHMc elticbear.com> wrote:

Is there some way to make a table have alternating
colors for rows when you're generating the table data
with a WHILE statement?

You should check this out:

http://www.alistapart.com/articles/zebratables/

bblackmoor
2004-03-17