Re:
| From: | nikos | Date: | Wed, 23 Apr 2003 14:14:36 +0000 |
| Subject: | Re: | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27301@lists.php.net to get a copy of this message | ||
RE: [PHP-DB]Is there another way?
With LIMIT I must set the "length" of select ( ... LIMIT 4, #). So I have to
select the Last_insert_id() first.
Is there another "fancy" way to select NOT THE FIRST 3 records but the rest
of them?
----- Original Message -----
From: Snijders, Mark
To: 'nikos'
Sent: Wednesday, April 23, 2003 4:15 PM
Subject: RE: [PHP-DB]
why without limit if i may ask?
-----Original Message-----
From: nikos [mailto:nikos@qbit.gr]
Sent: woensdag 23 april 2003 15:17
To: Matt Schroebel
Cc: PHP-mailist
Subject: Re: [PHP-DB]
Thanx Matt
but it doesn't help me much. I need a solution without using LIMIT.
----- Original Message ----- From: Matt Schroebel
To: nikos ; PHP-mailist
Sent: Wednesday, April 23, 2003 3:47 PM
Subject: RE: [PHP-DB]
> -----Original Message-----
> From: nikos [mailto:nikos@qbit.gr]
> Sent: Wednesday, April 23, 2003 8:22 AM
> To: PHP-mailist
> Subject: [PHP-DB]
> With LIMIT we can select (lets say) the first 3 records.
> How can I select the rest of the records without LIMIT?
Read the comments in the manual here:
http://www.mysql.com/doc/en/LIMIT_optimisation.html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php