alternate row2 colours

[stezz]

Hey! I know this topic has been covered before, but it still doesn't help me. As the topic of this posts tells us, I want alternate row colours in my table.

I have a while() loop... that's pulling out results from the db and printing them on the screen.

while($r = mysql_fetch_array($rersult)) {

      echo "<tr><td>kjbvdfskjbsd</td><td>jkvdsjknbsdv</td></tr>";

}

You get the idea. This is the format of my code... keeping to the same format, how could i make every other row a different colour?

Regards, Stezz.

[paulnaj]

Hi stezz,

There's a myriad of ways of doing it, here's one ...

<?php
// Have as many colours as you like
$bgcolors = array('white', 'yellow', '#C0C0FF');
$num_bgcolors = count($bgcolor);
$counter = 0;
while($r = mysql_fetch_array($rersult)){ // $rersult? or $result
	$bgcolor = $bgcolor[($counter++) % $num_bgcolors];
	echo '
	<tr>
		<td bgcolor="'.$bgcolor.'">kjbvdfskjbsd</td>
		<td bgcolor="'.$bgcolor.'">jkvdsjknbsdv</td>
	</tr>
';
}
?>

... extended to three colours, but you get the gist. You could easily adapt it to use alternating CSS class names instead.

Paul 🙂

[Installer]

$colors = array('green', 'orange');
$sw = true;
while($r = mysql_fetch_array($rersult)) { 
    echo '<tr bgcolor="' . $colors[$sw = !$sw] . '">' .
         '<td>kjbvdfskjbsd</td><td>jkvdsjknbsdv</td></tr>'; 
}

Edit: With CSS:

<style type="text/css">
.bgcolor0 {background-color: teal}
.bgcolor1 {background-color: aqua}
</style>

<?php

$sw = 0; 
while($r = mysql_fetch_array($rersult)) {
    echo '<tr class="bgcolor' . (int) ($sw = !$sw) . '">' . 
         '<td>kjbvdfskjbsd</td><td>jkvdsjknbsdv</td></tr>';  

}

?>

[bodzan]

$i=0;
while($r = mysql_fetch_array($rersult)) {
     echo "<tr";
     if(($i%2)==0){
           echo " bgcolor=\"#666666\"";      

     }
     else{
           echo " bgcolor=\"#ffff00\"";
     }

 echo  "><td>kjbvdfskjbsd</td><td>jkvdsjknbsdv</td></tr>";

 $i++;
}