Alternate Row colors from database query

[Zergman]

So I have it working using this

 

<?php
$count++;
if(($count % 2) == 1){
$background = "#CCCCCC";
} else {
$background = "#FFFFFF";
}
?>

 

Then in my tr tag

<tr bgcolor="<?php echo $background; ?>">

 

Works great, except I want the colors to be defined in my stylesheet, not on the page itself so my users can change themes and have the row colors change too.

 

I found a tutorial here http://lorenzod8n.wordpress.com/2007/06/02/alternating-row-color-in-htmlcss-with-php/ but I can't seem to get it to work with a database query.

 

Suggestions?

[teng84]

So I have it working using this

 

<?php
$count++;
if(($count % 2) == 1){
$background = "#CCCCCC";
} else {
$background = "#FFFFFF";
}
?>

 

Then in my tr tag

<tr bgcolor="<?php echo $background; ?>">

 

Works great, except I want the colors to be defined in my stylesheet, not on the page itself so my users can change themes and have the row colors change too.

 

I found a tutorial here http://lorenzod8n.wordpress.com/2007/06/02/alternating-row-color-in-htmlcss-with-php/ but I can't seem to get it to work with a database query.

 

Suggestions?

 

use classes of css

 

eg ..

 

<?php
$count++;
if(($count % 2) == 1){
$class = "style1";
} else {
$class = "style2";
}
?>
<tr class="<?=$class ?>">

[samshel]

you define two classes in your style sheet

oddRow

evenRow

 

and use like this..

 

if($i % 2 == 0 ) $class = "oddRow"; else $class = "evenRow";
<tr class="<?php echo $class; ?>">

 

[Zergman]

You guys rock!  Works like a freakin charm

 

Thanks for the help!

[DarkWater]

use classes of css

 

eg ..

 

<?php
$count++;
if(($count % 2) == 1){
$class = "style1";
} else {
$class = "style2";
}
?>
<tr class="<?=$class ?>">

 

Don't use short tags. =P

[Zergman]

Don't use short tags. =P

 

What do you mean?

[MFHJoe]

Use <?php echo $class; ?> instead of <?=$class ?>. Short tags don't work on some servers depending on how they're configured.

[DarkWater]

Don't use short tags. =P

 

What do you mean?

 

Umm, teng84 used short tags in his code.  Instead of typing <?php echo $variable; ?>, short tags allow you to do <?=$variable?>.  These are not guaranteed to work on all servers, and therefore are considered poor programming practice.  (Wow, that was some pretty good alliteration.  *pats self on back*)

[Zergman]

Good to know, thanks for the info