Re: Display Records in Multiple Pages
| From: | Jason Wong | Date: | Thu, 27 Jun 2002 14:09:06 +0000 |
| Subject: | Re: Display Records in Multiple Pages | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104170@lists.php.net to get a copy of this message | ||
On Thursday 27 June 2002 21:22, Erik Price wrote:
> On Thursday, June 27, 2002, at 02:56 AM, Justin French wrote:
> > Use the LIMIT function in your SELECT query... check out the MySQL
> > manual...
> > and then generate back / forward links depending on your current
> > offset. It
> > should be expandable to 1000 records without any mods to the code.
>
> Justin,
>
> Out of curiosity, why is it only expandable to 1000 records? What
> happens after that? I thought that (in theory) you can keep going with
> this kind of scheme. Or is there a limitation in MySQL that I'm not
> aware of... ?
If IIRC the OP said s/he had 1000 records to display.
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Nothing is but what is not.
*/