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:[EMAIL PROTECTED]]
> Sent: Friday, September 21, 2001 1:44 PM
> To: [EMAIL PROTECTED]
> 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 !!
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to