Selecting just 'N' first rows

Hello How can I send a query that retrieves only the first 'N' rows that match a condition? As far as I know you must call mysql_fetch_row() until the last row has been processed or the resources allocated won't be free. Am creating a program in PHP that should retrieve only 'N' records each

Re: Selecting just 'N' first rows

Look up the LIMIT clause of SELECT statement, also ASCENDING/DESCENDING - depending on how you want it. Remember LIMIT can take a number and an offset. Terry - Original Message - *From:* Renito 73 [EMAIL PROTECTED] *To:* mysql@lists.mysql.com *Date:* Sun, 9 Sep 2007 10:05:52 -0500

Re: Selecting just 'N' first rows

How can I send a query that retrieves only the first 'N' rows that match a condition? As far as I know you must call mysql_fetch_row() until the last row has been processed or the resources allocated won't be free. Am creating a program in PHP that should retrieve only 'N' records each time a