How to run multiple Update Queries in single statement in PHP and mySQL

I want to run the multiple queries in single stateme开发者_如何学Gont how to do this.

you will have to use mysqli instead of mysql.

Please refer to the following

http://php.net/manual/en/book.mysqli.php

http://php.net/manual/en/mysqli.multi-query.php

You can run multiple queries using mysqli::multi_query()

as the mysql_ function family does not provide feature to execute multiple queries in once.