Re: $mysqli-query does not execute multiple statements

[Jason Wisdom]

Thank you; outputting the error led me to the fix.

There were 2 problems. 1, $mysqli does not like executing commands after looping through a resultset, for some reason.

2, was more simple yet subtle--when building the 3rd query (based on results from query #2) I appended a "<br/>" to the end of the $sql so I could echo it cleanly. But of course it threw a syntax error when executed in mysql. And, of course, I couldn't see the problem by using echo($sql)...until I looked at page source. Fun times.

Thanks again.