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
Originally, I had:
foreach ( . . . .
$sql. = "insert into psc (pid, lft, rgt) values
($pid, $lft, $rgt);";
. . . [next sql statement, which fails with the "commands out of
Now, the only solution I've found is to change my simple multi_query to:
It seems like there should be a better solution than my current one?
Thanks for any suggestions,
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