This code works perfectly but I can't figure out how to wrap a pagination code with it. Does anyone have a simple pagination script that would work with this or know how to make it work?
Thanks
<HTML>
<HEAD>
<TITLE>Alternating Table Row Colors Using a MySQL Database and PHP</TITLE>
</HEAD>
<BODY>
<?php
$dbname="xxx";
$hostserver="xxx";
$username="xxx";
$password="xxx";
$db = @mysql_connect("$hostserver","$username","$password")
or die ("Problems connecting to database server");
@mysql_select_db ("$dbname") or die ("Problem selecting database");
$query = "SELECT * from birdhouses, birdhouse_images where (birdhouses.imageid = birdhouse_images.imageid)";
$result = @($query) or die ("Query failed");
$numofrows =@mysql_num_rows($result);
?>
<TABLE BORDER="1" cellspacing="1" cellpadding="3" align="center" class="productpagetable">
<TR bgcolor="#663300"><td> </td><TD>Birdhouse Name</TD><TD>Dimensions</TD><TD>Price</TD><TD</TR>
<?php
for ($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_assoc($result); if ($i % 2) {
echo "<TR bgcolor=\"#F5F5DC\">\n";
} else {
echo "<TR bgcolor=\"#CCFFCC\">\n";
}
echo "<TD>"."<a href='displaybirdhouses.html?id=$row[bird_id]'><img border=0 height=106 width=76 alt='$row[bird_name]' src='images/birdhouses/$row[frontimage]'></a>"."</td>
<TD>"."<a href='displaybirdhouses.html?id=$row[bird_id]'>$row[bird_name]"."</TD>
<TD>"."$row[bird_size]"."</TD><TD>"."$$row[bird_price]"."</td>\n";
echo "</TR>\n";
}
?>
</TABLE>
</BODY>
</HTML>
