Problem with multiple query syntax?

[matthewdingley]

Hi,

I've been using the following code:

mysql_query("DELETE FROM $tableName WHERE id='$quizId';
DELETE FROM $tableName2 WHERE quizId='$quizId'",$db) or die (mysql_error())

but it generates the following error:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; DELETE FROM hdc_quiz_questions WHERE quizId='10'' at line 1

I've looked through the documentation and in other posts but I can't find my problem. Can anyone help?

Thanks,

Matthew Dingley

[________]

Seems like there is a problem with deleting from two tables in one query. Try running two queries!