multi_query "Commands out of sync" after Insert

["J. Hill" <jh@xxxxxxxxxxx>]

I wouldn't think there would be a result set from a mysqli multi_query 
when the query is a group of insert statements (there is no 
auto_increment column), but I get a "commands out of sync" error on my 
next query.

Originally, I had:

      foreach ( . . . .
                  $sql. = "insert into psc (pid, lft, rgt) values 
($pid, $lft, $rgt);";
     }
     if(!$mysqli->multi_query($sqlgeo)) {
              echo $mysqli->error;
     }
     . . . [next sql statement, which fails with the "commands out of 
sync" error]

Now, the only solution I've found is to change my simple multi_query to:

       if($mysqli->multi_query($sqlgeo)) {
              
do{if($result=$mysqli->store_result()){$result->close();}} 
while($mysqli->next_result());
       }else{
               echo $mysqli->error;
       }


It seems like there should be a better solution than my current one?

Thanks for any suggestions,

Jeff

Using PHP 5.2.3, MySQL standard-5.0.27 on Debian Etch

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php