Re: Listing A Certain # Range

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> LIMIT 5,10
> LIMIT 10,15
>
> Something like that should work.

Not quite. LIMIT n,m where n is the starting point and m is how many rows
you want returned.

LIMIT 5 or LIMIT 0,5
LIMIT 5,5
LIMIT 10,5
etc...

---John Holmes...

> Im using MySQL and PHP 4.2.3 on Apache and Mandrake Linux, I was
> wondering how to get PHP to list let says row 5 - 10 from a database, I
> read the MySQL manual and all I could find is LIMIT 0,5 to list just the
>
> first 5, but I dont know how to make that list 5 - 10 or 10 - 15. Any
> help would be appreciated.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux