Re: Performing Multiple Prepared Queries
| From: | Nathaniel Hall | Date: | Wed, 03 Oct 2007 18:39:55 +0000 |
| Subject: | Re: Performing Multiple Prepared Queries | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-262699@lists.php.net to get a copy of this message | ||
Carlton Whitehead wrote:
> Hi Nathaniel,
>
> When your query starts its second loop, the resultset from the first
> one is still defined as the resultset in your prepared statement
> object. Before you can get another resultset, you need to clear the
> first one using the mysqli_stmt_free_result function. It would
> probably be best to place the free_result call after each call to
> fetch. Check
> http://www.php.net/manual/en/function.mysqli-free-result.php
> for more
> details about it.
>
I thought I had tried that, but apparently not. It works now. Thanks
for the help.
--
Nathaniel Hall, GSEC GCFW GCIA GCIH GCFA
Spider Security