runs in phpmyadmin but not mysqli

[cupboy]

the statement:

SET @v1 = 5; select @v1

the mysqli error:

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 '; select @v1' at line 1

This runs just fine in phpmyadmin though. What's the problem with running it with mysqli ?

The prepare fails.

[Weedpacket]

Does the MySQLi interface allow multiple statements per mysqli_query()?

[cupboy]

Yea, could be the last time I did something like this I used a stored procedure. I guess that's what I'll do.

[bradgrafelman]

AFAIK, you can't execute multiple queries via mysqli_query() - that's what [man]mysqli_multi_query/man is used for...

[Ashley_Sheridan]

I believe that you can run the queries one after the other and it will work as intended.