Alternating row color in output?

[Anon]

This may seem like a trivial question for some of you, but how do you alternate the colors of rows (to give a greenbar effect) on large tables of output? I can output the table with no problem, but am having diffiulty with alternating olors to make the rows easier to read.

Thanks a million.

[Anon]

Chester Bullock wrote:

This may seem like a trivial question for some of you, but how do you alternate the colors of rows (to give a greenbar effect) on large tables of output?

You can do something like this in your loop

for($i=0;$i<$num;$i++) {

if(1 & $i) { // Yes, one & - bitwise comparison
$color = "#FFFFFF";
} else {
$color = "#CCCCCC";
}

print "<tr bgcolor='$color'><td>data</td></tr>\n";
}

[Anon]

Another approach:

$row1 = "#cfdafg";
$row2 = "#ff0000";
$rowcolor = $row1;

while ($myrow = mysql_fetch_array($result)) {
printf'<tr bgcolor="%s"><td>whateverdata</td></tr>', $rowcolor);
if ($rowcolor == $row1) $rowcolor = $row2;
if ($rowcolor == $row2) $rowcolor = $row1;
}

[Anon]

I keep a counter, which incremements itself each time a row is being output. If the row is even, ie ($count % 2) == 0, then the row is one color, if it's odd, it's another color.

[Anon]

The code I use is:

for ($i=1; $i < $limit; $i++)
{
$bgcolor = ($i%2 == 0)?$M_COLOR_ODD:$M_COLOR_EVEN;
print "<TR BGCOLOR='$bgcolor'>\n";

...etc.etc...etc..
}

where of course $M_COLOR_EVEN is one color and $M_COLOR_ODD is another ;-)

[Anon]

I had to modify this one a little bit to get it to work right (for me anyhow), but this set me in the right direction. Thanks to all.

[Anon]

Chezz

I have tried your coding but only get 1 background colour. I don't know what I have input wrongly.

can you please take a quick look and let me knwo what is wrong

Code:

  for ($i=1; $i<count($info); $i++)
       {
          $bgcolor=($i%2 == 0)?"#80FF80":"#FF8080";
          .
          .
          .
          <tr bgcolor="$bgcolor"><td etc>

I have tried changing the $i%2 == 1 the result is the same
#80FF80 is a lime colour
#FF8080 is a rose colour

Thanks

Tony

[Anon]

Ithink you will want to set your bgcolors to variables ahead of time

[Anon]

Use Louie's suggested method above. I did after modifying the last two lines to if ... elseif statements and it works like a charm.

[Anon]

Can someone give me an entire HTML code.. not just these pieces. I am very confused.. I need these alternating rows too but don't know exactly where this source should go in relation to my table

[Anon]

Here it is, more or less...

$color1 = "#ffffff";
$color2 = "#d0d0d0";
$rowcolor = $color1;
if ($myrow = mysql_fetch_array($thisyear)) {

echo "<center><table border=0 cellspacing=2>\n";

echo "<tr><th bgcolor=#B75B00>Column Header</th></tr>\n";

do {
printf(
"<tr bgcolor=%s><td>row 1 and associated info</td></tr>\n", $rowcolor);
if ($rowcolor == $color1) {$rowcolor = $color2;}
elseif ($rowcolor == $color2) {$rowcolor = $color1;}

} while ($myrow = mysql_fetch_array($thisyear));

That should be enough for you to go on...

[Anon]

Yes, Louie's code above does work perfectly (using if..elseif). My problem was I kept taking the quotes off the color hex values. D'oh!
You must state $rowcolorvar="#cccccc" using the single or double quotes.

[Anon]

This is just what I need to accomplish but don't really understand how to use ($count % 2 == 0

Can you help me with the following real application ?

$BgcolorOne="EEEEEE";// lt grey
$BgcolorTwo="CDCDCD";// med grey

echo "<table border=\"1\" cellpadding=\"2\" BGCOLOR=\"#FFFFCC\">";

    $result = mysql_query("select Name,TelNumber,City From Friends where City='$City'");
        while($row=mysql_fetch_array($result,MYSQL_ASSOC)) {
        $j=mysql_num_fields($result);
            for($i=0;$i<$j;$i++) {
            $k=mysql_field_name($result,$i);
            $$k=$row[$k];
            }

$bgcolor = $BgcolorOne;
$i % 2  ? 0: $bgcolor = $BgcolorTwo;
echo "<tr bgcolor='$bgcolor'>";
echo "<td>$Name</td><td>$TelNumber</td><td>$City</td></tr>";
}

Thank you very much !
Peter