Table row colors

Anon

Hi,
Would anyone know exactly how to automatically get <tr> background colors to alternate (ie: blue-white-blue-white, etc.) on a results page? In fact, I am trying to get an effect exactly as this forum page is, as an example.

Any help would be appreciated! Thank You!

mattw

give this a try:

for($i=0; $i < $maxrows;$i++) {
if($i % 2) {
$bgcolor="white";
} else {
$bgcolor="blue";
}
echo "<TR bgcolor=\"".$bgcolor."\">";
//etc...etc

}

Matt Wade
codewalkers.com

terje-s

I use a slightly different approach than Matt on this one. An example:

$TR = 0; // global
function tr() {
global $TR;
if (!$TR) {
print '<tr bgcolor="#0000ff">';
$TR = 1;
} else {
print '<tr bgcolor="#ffffff">';
$TR = 0;
}
}

Now every time I need a <tr>, i just call the function tr();, and it automatically changes the background color. Remember to reset $TR; if you have multiple tables on one page, as it may look stupid with one starting white, one starting blue etc.

Another thing to keep in mind is that not all browsers support tr bgcolor. You might want to use a tr() function that sets the $TR, and a td() function to make tds with right bgcolor, as this is supported by all (graphical) browsers I've tried. (Actually, tr bgcolor is also supported by most major browsers such as newer Netscapes and Internet Explorer).

Anon

Thank you both for your help - I appreciate it!. However, I could not get either of these to work, and the reason is I am new to PHP, and I do not know where to place the code you have provided.

I have the code below, and if you could fill me in on where I should place this code, I would appreciate it.

Thank You!

...
<?

$db_name = "db";
$table_name = "table";

$connection = @mysql_connect("localhost", "xxx", "xxx") or die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

$sql = "SELECT id, stock, year, make, model, description
FROM $table_name
ORDER BY make
";

$result = @($sql,$connection) or die("Couldn't execute query.");

$contact_list = "<ul>";

while ($row = mysql_fetch_array($result)) {

$id = $row['id'];
$year = $row['year'];
$make = $row['make'];
$model = $row['model'];
$description = $row['description'];

$contact_list .= "<li><span class=info><a href=\"record.php3?id=$id\">$year $make $model</a> - $description</span>";

}

$contact_list .= "</ul>";

?>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<? echo "$contact_list"; ?>
</td>
</tr>
</table>

<p><a href="panel.php3">Return to Main Menu</a></p>

</BODY>