Re: anybody knows this error?
| From: | René Moonen | Date: | Thu, 20 Jun 2002 12:49:43 +0000 |
| Subject: | Re: anybody knows this error? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103106@lists.php.net to get a copy of this message | ||
In that case, you could consider using
PHP
$NrRecords= mysql_num_results($result_ID);
SQL
SELECT COUNT(*) FROM yourtable WHERE 1;
René
W. Enserink wrote:
I am quering my db. Since I want to know how many records I got back I use $count=count($result_array); . ----- Original Message ----- From: "1LT John W. Holmes" <holmes072000@charter.net> To: "Wilbert Enserink" <wilbert@pdd.nl>; <php-general@lists.php.net> Sent: Thursday, June 20, 2002 2:10 PM Subject: Re: [PHP] anybody knows this error?Duh...you're using to much memory. Why are you loading the results into an array? ---John Holmes... ----- Original Message ----- From: "Wilbert Enserink" <wilbert@pdd.nl> To: <php-general@lists.php.net> Sent: Thursday, June 20, 2002 8:00 AM Subject: [PHP] anybody knows this error? Hi all, I made this script resulting in this error. The script querys a db with 1800 records and puts all values into a new array using a counter while ($queryresult=mysql_fetch_array($result_ID)) { $result_array[$counter]=$queryresult; $counter=$counter+1; } Fatal error: Allowed memory size of 26214400 bytes exhausted (tried to allocate 35 bytes) Anybody knows what this error is about and how to overcome this error? thx Wilbert ------------------------- Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl info@pdd.nl -------------------------------------------------- Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl info@pdd.nl -------------------------