I'm trying to find a way to do multiple MySQL inserts with one query to reduce the load on my server. The queries have all been error checked so I'm not worried about that (I know some will still recommend against this). I've tried seperating the queries with ; or enclosing them in quotes or brackets. None of this worked of course. I've seen other postings that said this was not possible, but I just wanted to make sure. Does anybody know of a way to do this?
ex.
$query = "INSERT INTO tblOne (field1, field2...) VALUES (value1, value2...); INSERT INTO tblTwo (field1, field2...) VALUES (value1, value2...);"
$result = mysql_query($query);
jtjanes
