Re: Display Records in Multiple Pages
| From: | Erik Price | Date: | Thu, 27 Jun 2002 13:22:41 +0000 |
| Subject: | Re: Display Records in Multiple Pages | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-104152@lists.php.net to get a copy of this message | ||
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... ? Erik ---- Erik Price Web Developer Temp Media Lab, H.H. Brown pricee@hhbrown.com