php-db | 2002122
Date: 12/16/02
- Next message: NIPP, SCOTT V (SBCSI): "[PHP-DB] Oracle/PHP question..."
- Previous message: Aaron Wolski: "RE: [PHP-DB] Listing A Certain # Range"
- In reply to: Aaron Wolski: "RE: [PHP-DB] Listing A Certain # Range"
- Next in thread: conbud: "[PHP-DB] Re: Listing A Certain # Range"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
- Next message: NIPP, SCOTT V (SBCSI): "[PHP-DB] Oracle/PHP question..."
- Previous message: Aaron Wolski: "RE: [PHP-DB] Listing A Certain # Range"
- In reply to: Aaron Wolski: "RE: [PHP-DB] Listing A Certain # Range"
- Next in thread: conbud: "[PHP-DB] Re: Listing A Certain # Range"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

