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

[Mike Peters]

On 2004-03-07, LRW 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'd do it something like this:

$i = 1;
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$bgcolour = ($i%2) ? 'bgcolor=\'whit e\'' : 'bgcolor=\'grey \'';
++$i;
$names .= "<tr align=left " . $bgcolour . "><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who['email']."</td></tr>";
}
}

--
Mike Peters
mike [-AT-] ice2o [-DOT-] com
http://www.ice2o.com

[Pedro Graca]

LRW 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

Try this:
<?php
$i = 0;
$j = 20;
while (--$j) {
$i = 1 - $i; // 1, 0, 1, 0, 1, 0, 1, 0, ...
echo 'class="', ($i)?('odd'):(' even'), '"', "\n";
}
?>

Adapt to your liking.
--
--= my mail box only accepts =--
--= Content-Type: text/plain =--
--= Size below 10001 bytes =--

[LRW]

"Mike Peters" <o0************ ****@THIShotmai l.com> wrote in message
news:b3******** *************** *******@news.te ranews.com...

I'd do it something like this:

$i = 1;
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$bgcolour = ($i%2) ? 'bgcolor=\'whit e\'' : 'bgcolor=\'grey \'';
++$i;
$names .= "<tr align=left " . $bgcolour . "><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who['email']."</td></tr>";
}
}

Excellent! Perfect! Works prefectly. =)
Thanks you! (Oh...I can do so much with this....)
Thanks! =)
Liam

[Tim Van Wassenhove]

On 2004-03-07, 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? =)

There was recently a nice article on this:
http://www.alistapart.com/articles/zebratables/

--
http://home.mysth.be/~timvw

[Five Cats]

In message <rMM2c.79807$ko 6.426465@attbi_ s02>, LRW
<dr***@NOSPAHMc elticbear.com> writes

"Mike Peters" <o0************ ****@THIShotmai l.com> wrote in message
news:b3******* *************** ********@news.t eranews.com...

I'd do it something like this:

$i = 1;
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$bgcolour = ($i%2) ? 'bgcolor=\'whit e\'' : 'bgcolor=\'grey \'';
++$i;
$names .= "<tr align=left " . $bgcolour . "><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who['email']."</td></tr>";
}
}
Excellent! Perfect! Works prefectly. =)
Thanks you! (Oh...I can do so much with this....)
Thanks! =)
Liam

The above is how I would have done it, except that I would use CSS & a
class to set the background so I can change it later to suit without
having to fiddle with the PHP - one day I might want alternate pale
green & pale pink - you never know!

--
Five Cats
Email to: cats_spam at uk2 dot net

[Shawn Wilson]

LRW 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>";
}
}

I personally don't like counters. I use something like this:

//At top of file
$bgcolor1 = '#FF0000';
$bgcolor2 = '#00FF00';

//where you want your table to go
$bgcolor='';
while ($foo = mysql_fetch_arr ay($result)) {
$bgcolor = ($bgcolor == $bgcolor1) ? $bgcolor2: $bgcolor1;
echo '<tr><td bgcolor="'.$bgc olor.'">stuff</td></tr>';
}

Or use a CSS class using the same method. I find the code is tidier than using
a counter. I imagine it's slower than a counter because it has to compare
strings every loop. But unless you have gigantic tables you probably won't
notice a difference.

Regards,
Shawn
--
Shawn Wilson
sh***@glassgian t.com
http://www.glassgiant.com

[LRW]

Five Cats wrote:

In message <rMM2c.79807$ko 6.426465@attbi_ s02>, LRW
<dr***@NOSPAHMc elticbear.com> writes

"Mike Peters" <o0************ ****@THIShotmai l.com> wrote in message
news:b3****** *************** *********@news. teranews.com...

I'd do it something like this:

$i = 1;
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$bgcolour = ($i%2) ? 'bgcolor=\'whit e\'' :
'bgcolor=\'grey \'';
++$i;
$names .= "<tr align=left " . $bgcolour . "><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who['email']."</td></tr>";
}
}

Excellent! Perfect! Works prefectly. =)
Thanks you! (Oh...I can do so much with this....)
Thanks! =)
Liam

The above is how I would have done it, except that I would use CSS & a
class to set the background so I can change it later to suit without
having to fiddle with the PHP - one day I might want alternate pale
green & pale pink - you never know!

Well, that's a good idea! But...how do you do that in a CSS?
Oh! Instead of 'bgcolor=\'a_co lor\' use the class tag in that where/if?

Liam

[Eric Bohlman]

LRW <dr***@NOSPAHMc elticbear.com> wrote in
news:z893c.5063 50$I06.5412308@ attbi_s01:

Five Cats wrote:

$i = 1;
while ($row_RSwho = mysql_fetch_arr ay($RSwho)) {
if ($row_RSwho['name'] != "X") {
$bgcolour = ($i%2) ? 'bgcolor=\'whit e\'' :
'bgcolor=\'grey \'';
++$i;
$names .= "<tr align=left " . $bgcolour . "><td
width=120>".$ro w_RSwho['name']."</td><td
align=left>&nbs p;--&nbsp;".$row_RS who['email']."</td></tr>";
}
}

The above is how I would have done it, except that I would use CSS & a
class to set the background so I can change it later to suit without
having to fiddle with the PHP - one day I might want alternate pale
green & pale pink - you never know!

Well, that's a good idea! But...how do you do that in a CSS?
Oh! Instead of 'bgcolor=\'a_co lor\' use the class tag in that where/if?

Class *attribute*. Yep, change "bgcolor='white '" to "class='odd '" and
"bgcolor='grey' " to "class='eve n'". Then in your stylesheet set

tr.odd {background-color: white;}
tr.even {background-color: grey;}

One advantage is that you can do other things than just changing colors.
If you wanted to, you could make odd and even rows have different heights,
for example.

[Jerry Sievers]

"LRW" <dr***@NOSPAHMc elticbear.com> writes:

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

Set an array of two values on indexes 0 and 1.

Start iterating over the query rows with a counter that steps by 1.

Use a modulus 2 operation to select from the array.

$colors = array('red', 'blue');

$i = 0;
while(have-some-rows)
{
print $colors[$i % 2];
$i ++;
}

HTH

--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant
305 321-1144 (mobile http://www.JerrySievers.com/