Re: Help: Google like page functions
| From: | Ashley M. Kirchner | Date: | Tue, 23 Jan 2001 23:35:17 +0000 |
| Subject: | Re: Help: Google like page functions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-36287@lists.php.net to get a copy of this message | ||
Shane McBride wrote:
> If I have a MySQL DB that has 50 records in it and I want to display 5 per page. How do I do
> this. Also, 50 was just a nice round number, the number will change constantly.
$sql = "select * from table limit 0,5"; <-- first 5
$sql = "select * from table limit 5,5"; <-- next 5
$sql = "select * from table limit 10,5"; <-- next 5
etc.
AMK4
--
W |
| I haven't lost my mind; it's backed up on tape somewhere.
|____________________________________________________________________
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ashley M. Kirchner <mailto:ashley@pcraft.com> .
303.442.6410 x130
SysAdmin / Websmith . 800.441.3873 x130
Photo Craft Laboratories, Inc. . eFax 248.671.0909
http://www.pcraft.com . 3550 Arapahoe
Ave #6
.................. . . . . Boulder, CO 80303, USA