Multiple Queries

[radley]

Hi, when i try to use mutiple SQL statements seperated by semi-colons, it doesn\'t work, it only works if i do each sql statement with its own mysql_query() and take the semi-colon off, but i have lots of different insert statements and it would slow down the database if i had to do a lot of mysql_query()\'s.

[dar-k]

There's a very nice function for this right here: http://www.php.net/manual/en/function.mysql-query.php

[[deleted]]

Database only allow one query at a time, for obvious reasons of security and plain old common sense.

"and it would slow down the database if i had to do a lot of mysql_query()\'s."

And you think doing more queries in one command somehow magically makes the database do less work?

The only thing slowing down is PHP because it has to issue a new query over and over.