Re: anybody knows this error?
| From: | Peter Hicks | Date: | Thu, 20 Jun 2002 12:54:31 +0000 |
| Subject: | Re: anybody knows this error? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-103110@lists.php.net to get a copy of this message | ||
Hi Wilbert
Why not use $qry_handle->numrows to find out how many records there are in the
result set?
Muuuch more efficient!
Peter.
On Thu, 20 Jun 2002, 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
> -------------------------
>
>