How to use MySQL connection multiple times?

Question

PHP

mysqli_connect() works fine for one query, the next requires it to be reused to make another query.

Answer 1

this is a problem with Commands out of sync; you can't run this command now
You can't have two simultaneous queries because mysqli uses unbuffered queries by default (for prepared statements; reverse for vanilla mysql_query)
https://www.php.net/manual/en/ mysqli.next-result.php