Re: [PHP] Retrieving large results from a database ends in memory error.

2004-10-03 Thread Marek Kilimajer
Use mysql_unbuffered_query() RaTT wrote: Hi Guys I am trying to retrieve over 5000 rows from a mysql database, i have to use a "SELECT *" query as i am required to use all the fields for display. Everytime i try to run the code below i get a Allowed memory size of 10485760 bytes exhausted (tried

[PHP] Retrieving large results from a database ends in memory error.

2004-10-03 Thread RaTT
Hi Guys I am trying to retrieve over 5000 rows from a mysql database, i have to use a "SELECT *" query as i am required to use all the fields for display. Everytime i try to run the code below i get a Allowed memory size of 10485760 bytes exhausted (tried to allocate 40 bytes). Now if i change p