Yeah they all had semicolons already. Missed the single quotes around the table name on the previous line. That was the issue.
thanks again!
@alichani – added single quotes to the table on the previous line.. all good now. Thanks.
I did figure out that prepare wasn’t necessary for this, but thanks for reinforcing that.
I have reworked everything to use mysqli_multi_query() and I’m getting a syntax error:
First query failed…You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘SET @newid = last_insert_id()
SET @symbol = ‘COST’
SET @tagID = (SELECT tagID ‘ at line 4
