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
php's memory limit in the php.ini file to something like 80MB then its
fine, but i can't be guarantied that the person who this code is for
will be able or willing to access their php.ini file.
Basically what i am asking is there a better way to write this query
so i can still retrieve all the results from the database without
running into memory issues ? should i break it up into chunks and put
it through a loop ?
Any assitance on retriving large amout of info from a db would be most
appreciated.
THis is the basic code i am using:
$q = "SELECT * FROM `users` ORDER BY UserID";
$r = mysql_query($q) or die("There has been a query error: ".mysql_error());
if($getR = mysql_fetch_array($r,MYSQL_ASSOC)){
do {
$userarray[] = $getR;
}
while($getR = mysql_fetch_array($r));
echo 'Done retrieved '.count($getR).' records.';
}
else {
echo 'there has been an error retrieving the results.';
}
Thanks
Jarratt
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
