> 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