displaying data with max row

Anon

Dear All,
could you help me how to display data (query result) with max row defined.

ie. my query result in 50 rows and I want to display it 10 rows per page, how can I do it? should I requery every I open the next page? or there is buffer holding my last query?

any input from you will be very apreciated..

Regards,
Ferry

Anon

See this article:
http://www.phpbuilder.com/columns/rod20000221.php3

Anon

The basics of it...

IF (empty($max)) $max="0";

$query="SELECT * FROM db LIMIT $max, 5";

while($row=mysql_fetch_array($result0)) {
$name = $row[name];
print "$name<br>";
}

$more=$max+5;
$less=$max-5;

print "<br><a href=\"page.php?max=$less\">PREVIOUS 5</a>";
print "<a href=\"page.php?max=$more\">NEXT 5</a>";

Where the first int after LIMIT is what result row to start at, and the second is how many to display.

Anon

Dear Anders,

I would like to implement a max row display for my project and want to be sure I understand your example !

When you say:
print "<br><a href=\"page.php?max=$less\">PREVIOUS 5</a>";
print "<a href=\"page.php?max=$more\">NEXT 5</a>";

Is "page.php?max=$more" actualy the same query page/script ?
I start the query over again with the changed/incremented $max number !?

Thanks,
Peter M

Anon

Exactly!