[Resolved] Alternating Background Colour

dcooper

Hi Folks,

I'm making a little script that return's rows of results, to make them easier to read i'd like every other row to be a slighly different colour.

i.e
Rows 1 = Green
Row 2 = Blue
Row 3 = Green
Row 4 = Blue

Could anyone here point me in the right direction with a method of doing this.

many thanks
David

drawmack

<?php
$light = '#00FF00'; //green
$dark = '#0000FF'; //blue
?>
<table summary="">
<?php
    $color = $dark;
    for($i=0;$i<1000;$i++) {
        $color = ($color == $dark) ? $light : $dark;
        echo '<tr><td style="background-color:' . $color . ';">';
        echo $i . "</td></tr>\n";
    } //end for
?>
</table>

dcooper

How would that work from within a while loop?

<?php
	while ($data = mysql_fetch_array($result)) 
	{
	echo '<tr><td bgcolor='.$color.'>'.$data['forename'].'</td><td bgcolor='.$color.'>'.$data['surname'].'</td><td bgcolor='.$color.'>'.$data['student'].'</td><td bgcolor='.$color.'>'.$data['sex'].'</td><td bgcolor='.$color.'>'.$data['form'].'</td><td bgcolor='.$color.'>'.$data['score'].'</td><td bgcolor='.$color.'>'.$data['band'].'</td></tr>';
	}

TheDefender

Sorry draw, I know you have already provided the answer, but I had to step in here for a moment, because I wonder if anyone bothers to STFF anymore.

Pick a Thread from this simple search or check out this stickied thread right here in the coding forum.

dcooper, for future reference, before posting questions do a few searches, because chances are, you'll find it's been asked and answered before. (several times) Anyhow, since I am here, may as well help out.

<?php
$light = '#00FF00'; //green 
$dark = '#0000FF'; //blue  

$color = $dark;
    while ($data = mysql_fetch_array($result))  

    { 
$color = ($color == $dark) ? $light : $dark; 
    echo '<tr><td bgcolor='.$color.'>'.$data['forename'].'</td><td bgcolor='.$color.'>'.$data['surname'].'</td><td bgcolor='.$color.'>'.$data['student'].'</td><td bgcolor='.$color.'>'.$data['sex'].'</td><td bgcolor='.$color.'>'.$data['form'].'</td><td bgcolor='.$color.'>'.$data['score'].'</td><td bgcolor='.$color.'>'.$data['band'].'</td></tr>'; 
    }

[edit] Slight correction made. The $color=$dark needs to be outside of the loop.

dcooper

I always search the forums!

This time i tried "change each record color", and various other mixtures of that and found nothing.

Calm down you pedantic fool.

TheDefender

Look, I am not going to get into a flame war with you, and there's no need for name calling. My comment to search the forum doesn't mean you'll always find the EXACT answer... rather that you have to use your "imagination" to apply the principles you find throughout your searches... Isn't it ironic that a pedant himself has the audacity to throw his label around so freely?

dcooper

I searched and found nothing of any use, therefore i posted. I have always tried to follow the forum rules to the letter searching/setting resolved etc so dont take kindly to being bitched at.

TheDefender

Whatever. One thing you'll see is that I don't bitch at anyone. I was merely making an observation and helpful suggestion, since this topic has been covered hundreds and hundreds of times in the past (which is why it's in the sticky thread for the coding forum). Sometime, when you have a chance, you should check out the stickied threads. You'd be amazed at what you find in them. And don't overthink your searches... If you had searched for the term you titled this subject with, you'd have even found a result (which has the info you need right in it).

I wouldn't have meant to say you didn't search the forums, had it appeared as though you had, and don't take offense. You'd be amazed how many times newbies post this question without searching the forum, thinking they just had found some brand spaking new way to decorate table rows, and that nobody has ever thought of it first. So, no offense. Flip it around, and look at your original post from my point of view.