RE: [PHP] seoaration of results ?
| From: | o dot cook at etoncollege dot org dot uk | Date: | Sat, 18 Nov 2000 12:20:21 +0000 |
| Subject: | RE: [PHP] seoaration of results ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-26039@lists.php.net to get a copy of this message | ||
I use something like this:
# $page passed in URL
$offset = ($page - 1) * 10;
$limit = 10;
$sql = "SELECT fields FROM table WHERE condition=value LIMIT $offset,
$limit";
Ollie
> -----Original Message-----
> From: Gianni Ponzi [mailto:gianni@adept.co.za]
> Sent: 18 November 2000 11:12
> To: php-general@lists.php.net
> Subject: [PHP] seoaration of results ?
>
>
> Howdy
>
> how can I separate results from a DB eg 10 per page ?
>
> thanks
> Gianni
>