Welcome Guest, Not a member yet? Register   Sign In
Commands out of sync; you can't run this command now (with free_result())
#2

(This post was last modified: 02-04-2016, 12:44 AM by skunkbad.)

See this on my website:

http://community-auth.com/blog-posts/com...procedures


PHP Code:
$sql "call getCase( '$myTable', '$casenum', '$fname', '$lname')";    
$q 
$this->db->query($sql);    
$data
['hrg'] = $q->result();
/**
 * Free result is not good enough, because procedures 
 * will often return more than one result. The solution
 * is to use mysqli_next_result(). If you're not using
 * mysqli, then you're going to need to figure out how 
 * to get the next result using some other way.
 */
mysqli_next_result$this->db->conn_id ); 
Reply


Messages In This Thread
RE: Commands out of sync; you can't run this command now (with free_result()) - by skunkbad - 02-03-2016, 10:00 PM



Theme © iAndrew 2016 - Forum software by © MyBB