Re: Quickform with DB: throwing error with mysql.trace_mode = On , "2 result set(s) not freed. Use mysql_free_result to free result sets "
| From: | Justin Patrin | Date: | Mon, 12 Sep 2005 16:20:52 +0000 |
| Subject: | Re: Quickform with DB: throwing error with mysql.trace_mode = On , "2 result set(s) not freed. Use mysql_free_result to free result sets " | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-20926@lists.php.net to get a copy of this message | ||
On 9/12/05, l Burnerheimerton <lburnerheimerton@yahoo.com> wrote:
> I am processing a Quickform with DB data. I just
> turned mysql.trace_mode = On and this shows up. If I
> tuen it off, that does not show up. Either way, it
> processes fine.
>
> I had posted a week or two ago about whether I need
> to:
> $dbh->disconnect();
> on each page and was told that it's taken care of when
> the user leaves the script.
>
> So what do I need to do to solve this? Thanks.
>
> Error message:
> Warning: (null)(): 2 result set(s) not freed. Use
> mysql_free_result to free result sets which were
> requested using mysql_query() in Unknown on line 0
>
You don't need to do anything. As with all resources (variables,
memory, open filed, database connections) DB results are freed when
the script exits. However, if you were running this script for an
extended period of time (or were simply very resource conscious) you
could call free() on the statement handle when you're done with it.
--
Justin Patrin