alternating colors

Anon

I would like to output my data in a table generated by a database and would like to have each row alternate colors - just like this forum - I am fairly new to PHP and would really appreciate your help.

brandonschnell

take a look at this thread:

http://www.phpbuilder.com/forum/read.php3?num=5&id=6900&loc=0&thread=6900

</A>

Anon

simple answer:

$bgcolor = ($row_num%2) ? $color1 : $color2;

craigh

I did this once:

while...
echo "<TR BGCOLOR=$rowcolor><TD>";

if ($rowcolor == "#CCCC99") { //change row color//
$rowcolor = "#FFFFFF";
} else {
$rowcolor = "#CCCC99";
}
...}

but you get the idea

[deleted]

That is kind of what paul said, but paul said it in PHP-shorthand. :-)

Anon

This is what I am trying right now:

<table width="100%" border="0" cellspacing="2" cellpadding="2">
<?php

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

$result=mysql_query("select * from courses WHERE syllabus!='nos.php' ORDER BY title asc");
while ($courses = mysql_fetch_row($result)) {

printf ('<tr bgcolor="%s"><td> <font size="1" face="Verdana, Arial, Helvetica, sans-serif">$courses[0] - $courses[2] $courses[1]</font></td><td><font size="1" face="Verdana, Arial, Helvetica, sans-serif">$courses["title"]</font></td></tr>', $rowcolor);
if ($rowcolor == $row1) $rowcolor = $row2;
elseif ($rowcolor == $row2) $rowcolor = $row1;
}
?>

</table>

It pulls the info out of the database and gives me the right number of rows - just doesn't print the info - it prints my variable name

Help!

Andrew Smith wrote:

Anon

Made it work! This is what I did:

I figureded it out - I ditched the printf () and went with something I am more familiar with - print() this is how it worked:

<table width="100%" border="0" cellspacing="2" cellpadding="2">
<?php

$row1 = "#EEEEF8";
$row2 = "#ffffff";
$rowcolor = $row1;

$result=mysql_query("select * from courses WHERE syllabus!='nos.php' ORDER BY title asc");
while ($courses = mysql_fetch_row($result)) {

print "<tr bgcolor='$rowcolor'><td> <font size='1' face='Verdana, Arial, Helvetica, sans-serif'>$courses[0]</font></td> <td> <font size='1' face='Verdana, Arial, Helvetica, sans-serif'><a href='http://www.tyndale.ca/summer/viewcourse.php?id=$courses[0]' target='_blank'>$courses[1]</a> </font></td> <td><font size='1' face='Verdana, Arial, Helvetica, sans-serif'>$courses[2]</font></td></tr>";

if ($rowcolor == $row1) $rowcolor = $row2;
elseif ($rowcolor == $row2) $rowcolor = $row1;
}
?>

</table>

Thanks for all your suggestions!

Andy