Re: Limit in SELECT query.
| From: | Mircea Romanitan | Date: | Fri, 24 Nov 2000 15:58:17 +0000 |
| Subject: | Re: Limit in SELECT query. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-4723@lists.php.net to get a copy of this message | ||
Thanks Ollie.
But what if i want to make something like:
prev 1 2 3 4 next total records: 45
and each number to be a link to that group of 10 records ?
Must i first get the number of all records, and then query again the DB with
that limit ?
Thankx
----- Original Message -----
From: <o.cook@etoncollege.org.uk>
To: <mitch@lasting.ro>
Cc: <php-general@lists.php.net>
Sent: Friday, November 24, 2000 5:41 PM
Subject: RE: [PHP-DB] Limit in SELECT query.
SELECT fields FROM table WHERE field=condition LIMIT 0,10
... to get 10 records.
Ollie
> -----Original Message-----
> From: Mircea Romanitan [mailto:mitch@lasting.ro]
> Sent: 24 November 2000 15:32
> To: php-db@lists.php.net
> Subject: [PHP-DB] Limit in SELECT query.
>
>
> Hello.
>
> Can someone give me an example of SELECT query with limit?
>
> Thanx.
>
> Mircea
>