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

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 <renito73@gmail.com>
> *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/mysql?unsub=moscow@cix.co.uk
>
>
>
>
> --
> 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

> 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.

Why dont' you just use the LIMIT statement?

thnx,
Chris