Say I wanted to do
UPDATE table SET name = 'bob' and
UPDATE table SET age = 55 WHERE name = 'jim' how do I do them in the same mysql_query()?
EDIT: Since this question has a fair amount of views I'd like to point out that as of PHP 5.5
mysql_query and other
mysql_* functions are now deprecated and shouldn't be used.
I've never tried this, but I think you can use mysqli::multi_query. One of the good things about
mysql_queryrejecting multiple statements is that it immediately rules out some of the more common SQL injection attacks, such as adding
'; DELETE FROM ... #to a statement. You might therefore want to be careful with multiple statements.