Re: How to do this with PHP

On Friday 21 September 2001 21:47, Rick Emery wrote: > SELECT * FROM mytable LIMIT 0,5 > SELECT * FROM mytable LIMIT 6,5 > SELECT * FROM mytable LIMIT 11,5 > SELECT * FROM mytable LIMIT 16,5 It is advised to add ORDER BY _col_name_here_ to guarantee the order of rows retrieved (otherwise, you can't be sure about the order of rows returned - it could work but you shouldn't take a chance). For more info on this check PHP builder: http://www.phpbuilder.com/columns/rod20001214.php3 -- Meir Kriheli > -----Original Message----- > From: Alawi Albaity [mailto:phpcf@yahoo.com] > Sent: Friday, September 21, 2001 1:44 PM > To: php-db@lists.php.net > Subject: [PHP-DB] How to do this with PHP > > > I have a table .. > this table have 20 record.. > I want to view this record in the 4 pages (5 record by > page).. > how can I do that !! > >