Upon reading the other replies, I noted that they all pointed to the LIMIT
constraint in the SELECT statement. Fair enough...but not far enough.
Upon making your selection for page X, you must then pass a variable
(perhaps using the URL parameter) to indicate where you are, so that you
might know where you want to be. As a concrete example:
<?php
if( ! ISSET($page) ) { $page=1; }
else { $page += 10;}
$query = "SELECT * FROM mytable LIMIT $page,10";
$result = mysql_query($query) or die("Error: ".mysql_error());
....process result here ....
print "<A href=\"mypage.php3?page=$page\">Next 10</A>";
?>
-----Original Message-----
From: Auri Net SAC [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 3:25 AM
To: [EMAIL PROTECTED]
Subject: Show query page by page
Hi,
I have a query result with 50 register and i want to show them in 5 pages,
every page show 10 register.
Thanks , for your answers
Rhony
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
