Alternating Row Color

cravoz71

Can anyoine please help me with makeing the row color alternate. I have been stuck on this for a few days. I can get it to work with this code:

<?php
$connection = mysql_connect ("localhost", "root", "");
if ($connection == false){
echo mysql_errno().": ".mysql_error()." ";

exit;
} //end if
$query = "select * from westvaco Where district = '$district'";
$result = mysql_db_query ("db", $query);
if ($result){
echo "<table width=490 border=0 cellspacing=0 cellpadding=2 align=center>";
echo "<tr>
<td align=center>Log File#</td>
<td align=center>District</td>
<td align=center>Tract Name</td>
<td align=center>Stand</td>
<td align=center>Acres</td>
</tr>";

$numOfRows = mysql_num_rows ($result);
for ($i = 0; $i < $numOfRows; $i++){
$row_class = ($i % 2) ? 'Data1' : 'Data2';
$image = mysql_result ($result, $i, "image");
$log_file = mysql_result ($result, $i, "log_file");
$district = mysql_result ($result, $i, "district");
$tractname = mysql_result ($result, $i, "tract_name");
$stand = mysql_result ($result, $i, "stand");
$acres = mysql_result ($result, $i, "acres");

echo "<tr class=\"$row_class\">
<td><a href=$image class=image>$log_file</a></td>
<td>$district</td>
<td>$tractname</td>
<td>$stand</td>
<td>$acres</td>
</tr>";

$row_count ++;

} //end for
mysql_free_result($result);
echo "</table>";

} else {

echo "
Sorry, no records were found.
";
} //end if
mysql_close($connection);
?>

BUT, with this new code that I am trying to use, I can not get it to work.

<?php
include "config.inc.php";

$offset = isset($GET['offset']) ? $GET['offset'] : 0;

$offsetOriginal = $offset;

$photoQueryResult = retrieve_album_page($offset);

$totalRows = mysql_numrows($photoQueryResult);

while ($row = mysql_fetch_array($photoQueryResult))

{

$photoID = $row['photoID'];
$photoFileName = $row['photoFileName'];
$log_file = $row['log_file'];
$district = $row['district'];
$tract_name = $row['tract_name'];
$stand = $row['stand'];
$acres = $row['acres'];

echo "<table width='500' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td width='100'>

<a href='map.php?photoID=$photoID&offset=$offsetOriginal' class='image'>$log_file</a>

</td>
<td width='100'>

$district

</td>
<td width='150'>

$tract_name

</td>
<td width='75'>

$stand

</td>
<td width='75'>

$acres

</td>
</tr>
<tr><td colspan='5'><img src='../images/ltblue_pix.gif' alt='' width='480' height='1' border='0'></td></tr>
</table>";
$offset++;

}

echo "<div>";
echo previous_page($offset, $totalRows);
echo " | ";
echo next_page($offset);
echo "</div>";
?>

Any help would be greatful!

bastien

create 2 css classes for the row color

if ($row_class == "class1"){$row_class="class2":}else{$row_class="class1";}

echo "<td class='$row_class"....";