RE: [PHP] limit in query

first of all an advice: for mySQL (SQL) "query" question go to mySQL.com and read the documentation. SELECT * FROM table WHERE I_look='like_you' ORDER BY id LIMIT 5,10; will pull out whatever it will find in the table and will --limit the result-- to 5 rows string from 6-th and ending with 10-th. hope it was clear enough. Cheers, Maxim Maletsky. -----Original Message----- From: Jacky [mailto:jacky@activelifestyle.com] Sent: Thursday, December 14, 2000 8:03 AM To: php-general@lists.php.net Subject: [PHP] limit in query Hi all, Can any one tell me what it means when you put LIMIT function on a query? I am a newbie and went to search in php.net but could not find it yet. Jack jacky@activelifestyle.com "Power is nothing without control