Re: Performing Multiple Prepared Queries

From: 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

« previous php.general (#262699) next »