Re: Multiple prepared statements and preparing a stored procedure...

nope!! unless u build 2 class.. that's for save actualy.. $db1 = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB); $db2 = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB); ----- Original Message ----- From: "Ken Keefe" <kjkeefe@gmail.com> To: <php-db@lists.php.net> Sent: Wednesday, June 06, 2007 1:14 AM Subject: [PHP-DB] Multiple prepared statements and preparing a stored procedure... > Is it possible to have multiple prepared statements associated with a > single mysqli object at one time? > > For example: > > $db = new mysqli($sqlServer, $sqlUser, $sqlPass, $sqlDB); > $query1 = $db->prepare($sql1); > $query2 = $db->prepare($sql2); > foreach ($arr as $key => $val) > if($val) > { > $query1->bind_param("s", $key); > $query1->execute(); > } > else > { > $query2->bind_param("s", $key); > $query2->execute(); > } > $query1->close(); > $query2->close(); > > > Also, is there any benefit to using a prepared statement to call a > stored procedure? If so, how do I prepare another statement after the > stored procedure? I keep getting an error about being out of sync... > > Thanks, > Ken > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >