Rotating table row colors using php

Anon

I'm trying to figure out how people use php and have tables output data as its rotating the background color of the rows.

If there's two rows of data in the table, I'd like it to print the first row with a background of (lets say) grey, then print the second row with a background of (lets say) white...

print '<table>';
$result = mysql_query("SELECT id,abc FROM table");
while($data=mysql_fetch_row($result)){
print '

<tr>
<td width="50%">' .$data[0]. '<td>
<td width="50%">' .$data[1]. '</td>
</tr>';
}
print '</table>';

This is an example of something off the top of my head but it doesn't have the code on how to rotate the colors. Anyone have an idea how to accomplish this?

Thanks

fitzbean

Each field a diff color, or each row?

IF EACH ROW:

print '<table>';
$result = mysql_query("SELECT id,abc FROM table");
while($data=mysql_fetch_row($result)){
if ($color == 'White') { $color = 'Grey'; } else { $color = 'White'; }

print '
<tr>
<td width="50%" BGCOLOR=$color>' .$data[0]. '<td>
<td width="50%" BGCOLOR=$color>' .$data[1]. '</td>
</tr>';
}

IF FIELDS:

print '
<tr>
<td width="50%" BGCOLOR=White>' .$data[0]. '<td>
<td width="50%" BGCOLOR=Grey>' .$data[1]. '</td>
</tr>';
}

rrijnders

print '<table>';

$result = mysql_query("SELECT id,abc FROM table");

$rowCount=0;

while($data=mysql_fetch_row($result)){

  $rowCount++;

  if (($rowCount%2)=0)) {
    $bgColor="#fcfcfc";
  }
  else {
    $bgColor="#ffffff";
  }

  print "<tr>
<td width=\"50%\" BGCOLOR=\"" . $bgColor . "\">" .$data[0]. "<td>
<td width=\"50%\">" .$data[1]. "</td>
</tr>";

}

print "</table>";

--Rich

Anon

Alright thx! 😃

Zimm

juschillin

or you can do it like this, but it's longer

static $cellcolor = "#DFFFDF";
function AltCellColor()
{
static $cellcolor = "#DFFFDF";
if($cellcolor == "#DFFFDF")
{
$cellcolor = "#EEFFEE";
}
else
{
$cellcolor = "#DFFFDF";
}
return($cellcolor);
}
while($row = mysql_fetch_row($mysql_result))
{
$rowcolor = AltCellColor();
printf("<tr>");
printf("<td bgcolor=\"%s\">%s</td>", $rowcolor, $row[0]);
printf("<td bgcolor=\"%s\">%s</td>", $rowcolor, $row[1]);
printf("<td bgcolor=\"%s\">%s</td>", $rowcolor, $row[2]);
printf("<td bgcolor=\"%s\">%s</td>", $rowcolor, $row[3]);
print("</tr>");
}