Pagination & Alternate Row Color Question

artisticre

The code I have works but I am trying to add pagination and alternate row colors to the table. I know how to do both but I can't figure out how to add it to this particular page. Can someone please suggest something?

<?php
$db = mysql_connect("","","");
mysql_select_db("");

$result = mysql_query("SELECT * FROM ** ORDER BY packid");

echo '<table align=center border=0>';

while ($myrow = mysql_fetch_array($result)) {
?>
<tr>
<td width="100%" align="center">
<table border="0" align="center">
<tr>
<td width="100%" align="center"><b><i><?php echo $myrow['card_pack_name']; ?></b></i></td>
</tr>
<tr>
<td width="100%" align="center"><i><?php echo $myrow['assort']; ?></i></td>
</tr>
<tr>
<td width="100%" align="center"><i><?php echo $myrow['dimensions']; ?></i></td>
</tr>
<td width="100%" align="center"><?php $packs = mysql_query("SELECT distinct greeting_card_name, filename FROM *** WHERE (greetingcards1.packid = $myrow[packid])");
while ($rows = mysql_fetch_array($packs)){
?>

<a href='/.html?id=<?php echo $myrow[packid];?>'><img width="116" height="126" alt="<?php echo $rows['greeting_card_name']; ?> - Click on the image for a larger view" src="http://www./<?php echo $rows['filename']; ?>"></a>

<?php } ?></td>
</tr>
<tr><td width="100%" align="center">$<?php echo $myrow['price']; ?></td>
</tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
</table>

<?php } ?>

lazzy

function getrowbg () {
	global $bgcounter;
	if ($bgcounter++%2==0) {
		return "firstalt";
	} else {
		return "secondalt";
	}
}

learned this one from vb. Use css and create those fields in there.