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 > > 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 time a query is sent, so I I'm thinking on using > mysql_free_result(), but, is it safe to free the results even if > there are more records remaining that match the query conditions? > > I need to know how secure could be to read only the first records and > free the resources, or if there is another way to do the same thing. > > Thanks, > Miguel > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.485 / Virus Database: 269.13.10/995 - Release Date: > 08/09/2007 13:24 > > Terry http://booksihaveread.awardspace.co.uk -- No virus found in this outgoing message. Checked by AVG. Version: 7.5.485 / Virus Database: 269.13.10/995 - Release Date: 08/09/2007 13:24 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
