RE: [PHP-DB]
| From: | Matt Schroebel | Date: | Wed, 23 Apr 2003 15:08:33 +0000 |
| Subject: | RE: [PHP-DB] | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27303@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: nikos [mailto:nikos@qbit.gr]
> Sent: Wednesday, April 23, 2003 10:15 AM
> To: Snijders, Mark
> Cc: PHP-mailist
> Subject: Re: [PHP-DB]
>
>
> 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.
On that link I sent, the user notes say use LIMIT 4,-1 to get the rest
of the items. -1 being the length ...
http://www.mysql.com/doc/en/LIMIT_optimisation.html