MySQL Forums
Forum List  »  Newbie

Re: Same QUERY not working on PHP and works in MySQLWorkbench
Posted by: Barry Galbraith
Date: June 25, 2023 01:11AM

How are you trying to execute your multiple SQL statements?
If you are using mysqli->query() you can only put one query at a time.
To execute multiple SQL in one go you need to use mysqli->multi_query();

USE mmike_devtest; should be put as a
$mysqli->select_db('mmike_devtest');

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: Same QUERY not working on PHP and works in MySQLWorkbench
June 25, 2023 01:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.