Send 2 sql statements in 1 query

[PLAnt]

Hello ppl,

How can I send 2 query's in one mysql_query($sql)?
I thought I could use ';' to separate the query's, but I can not do it! 🙁

For example:

$sql="INSERT INTO table1 (name) VALUES ('john'); INSERT INTO table2 (name) VALUES ('john')";
mysql_query($sql);

It gives me an error of syntax 🙁

How can I send 2 query's in one statement?

Thanks in advance

[bubblenut]

You can't I'm afraid. You can at the command line but not through php.
There are a few ways of handling this; you could save all your queries into a file on the db_server in MySQL's directory and then do a LOAD DATA INFILE command, or you could save all the queries in that same file and then run shell_exec (if the db is on the same server as php, if not don't bother with this one) mysql -u db_user -p my_database < dbfile.sql, or you could just do them all seperatelt from your script (this is the way I do it, but then I never have huge amounts of data to insert.
HTH
Bubble
Oh.. there is one other way :evil grin: you could you could open a socket to mysql's data files and edit them directly Mwahahahahaha

[PLAnt]

OK!

Thank you a lot bubblenut