limiting rows and pages like google
| From: | Aniceto Lopez | Date: | Wed, 12 Sep 2001 08:28:35 +0000 |
| Subject: | limiting rows and pages like google | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-67017@lists.php.net to get a copy of this message | ||
paging results:
this is tha idea
page 1 - SELECT * FROM yourtable ORDER BY id DESC LIMIT 0, 20
page 2 - SELECT * FROM yourtable ORDER BY id DESC LIMIT 21, 20
page 3 - SELECT * FROM yourtable ORDER BY id DESC LIMIT 41, 20
...
so
$next = 0 //starting
SELECT * FROM yourtable ORDER BY id DESC LIMIT $next, 20
$next = $next + 20 //next pages
till $next > max(id)
is this helping you?
Ani Lopez
www.lamundial.net
download and spread our music