can you shorten this

[br__ken]

is there a way to do this that i dont know about? this works perfectly, but i was just wondering if theres an 'easier' way to do it..

<?
// assume $total = a query for every row (in my case its 6)
// $fr is set that mysql will LIMIT $fr, $fr+5
// i wanted to pass 'page' vars, but i decided that passing low-limit # was easier :-)
if(mysql_num_rows($total)>5)
{
	$pages=mysql_num_rows($total)%5;
	// start page table & init row //
	?>
	<table class=10 border=0 width="90%" align="center" cellspacing=2 cellpadding=2>
	<tr>
		<td width="5%">Page:</td>
		<td>[<a class=norm href="?fr=0">1</a>]&nbsp;
	<?
	for($i=1;$i<($pages+1);$i++)
		echo "[<a class=norm href=\"?fr=" . ($i*5) . "\">" . ($i+1) . "</a>]&nbsp;";

echo "</td></tr></table>";
}

[tomhath]

I can't shorten it, but it looks like this line is wrong:

$pages=mysql_num_rows($total)%5;

The modulo operator will give you the remainder after the division (for positive numbers anyway), it looks like you want the integer quotient (use either the floor() or ceil() function). Just happens to work right with 6 rows (quotient=1, remainder=1).

[br__ken]

wow, im glad you noticed that, i changed it to floor(total/5).

drunk php rocks! 😃