Hi

I have code where I connected to the database like so:

$db = new mysqli("localhost", "user", "pass", "company");

Now when I query the database like so:

//query calls to a stored procedure 'user_info' 
$result = $db->query("CALL user_info('$instruc', 'c_register', '$eml', '$pass', '')");
//I use the $result

This query works well. Now when I try and free that result like so:

$result->free(); 

or

$result->close();

It seems like it doesn't do anything because $result is still set. When I try to run another query it gives me this error: Fatal error: Call to a member function fetch_array() on a non-object in... For me to run this other query I have to close the db conection and connect again, then it will work. I want to know if there is a way I could run the other query without having to disconnect and reconnect to the database.

thanks in advance.