Alternating Row Colors?

tony_l

Hi all,

I am writing an application that will be querying from a MySQL DB. I am tired of the same old display, so I thought I would experiment and make the output look a bit better. The thing is, I have searched these forums and I cannot find anywhere on here how to make one row one color and the other row another color.

Can anyone tell me where to go to get info on how to make one row one color and the next row a different color? I am pretty sure it is easy to do using an increment operator, but I am not sure how to actually implement that.

Any help would be appreciated.

[deleted]

<?php
$i=0;
while($j<8){
	if($i)		$color = 'red';
	else		$color = 'blue';

print  $color."\n";
$i=!$i; //first option
$i=1-$i; // second option

$j++;
}

?>

rharter

here's another way

$color[1] = 'lightblue';
$color[0] = 'white';

for ($i=0;$i<count($row);$i++) {
// row is an array of fields to output
write_row($row[$i],$color[$i%2]);
}

BabeWalls

I am a complete nivice with php.

Could you please give an example of how these scripts would be used for the table?

daveyboy

Save as team.php or whatever, and run in a browser. Should display the LFC team sheet, and help you out, too.

<?php
// alternating rows for dynamic output

// html header 
echo '<html>
<head>
<title>Liverpool FC Team</title>
</head>
<body>
<h3>Liverpool FC Team</h3>
<table cellspacing="2" cellpadding="2">
	<tr bgcolor="#bbbbbb">
		<th>Number</th><th>Name</th>
	</tr>';

// now the dynamic stuff
// $colours holds the two colours we wish to alternate
$colours = array('#cdcdcd', '#eeeeee' );
// array to display - start at 1
$lfc = array (  1=> 'Dudek', 'Henchoz', 'Xavier', 
	'Hyypia', 'Baros', 'Babbel', 'Smicer', 'Heskey',
	'Diouf', 'Owen', 'Murphy' );

// the meat of the script. you can use any of the methods 
// above, too - just change the next few lines
$x = 0;
foreach ( $lfc as $num=>$name ) {
        // use $x to set the background colour
	echo "<tr bgcolor=\"". $colours[$x] ."\">
		<td>$num</td>
		<td>$name</td>
		</tr>";
	// set the colour for the next row
	if ( $x == 1 ) {
		$x = 0;
	} else {
		$x = 1;
	}
}
// end of the page
echo '</table></body></html>';
?>

intenz

Then you use the $bg variable for the alternative color.

while($myrow = mysql_fetch_assoc($query))
{
	$color = 0;
	if($color == 0)
	{
		$bg = 'red';
		$color = 1;
	}
	else
	{
		$bg = 'blue';
		$color = 0;
	}
}

mcgiddin

I know I'm not posting much useful info here, but pear's Table.php has a really nice alternating function built into it.

http://www.mamasam.com/index3.html

Matt

philwong

there is a much easier way

while($row = ......)
{

$bgcolor = ($bgcolor == "color1" ? "color2" : "color1");

}

Now then, that wasnt too hard!

face

Hii,

check the smarty template engine to solve such easy problems in an easier way :-)

website

cycle [ color flip ]]

heve fun,

face

jmaker

for($j=0; $j < mysql_num_rows($result); $j++)
         {
            # for every other row, display a different background color #
            if($j % 2 == 0)  # 2/2 = remainder 0 .... 3/2 = remainder 1 .... 4/2 = remainder 0...and so on #
            { $bgcolor = 'white'; }
            else { $trclass = 'blue'; } ?>

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

        etc....