Multiple delete through 1 mysql_query

[astralaaron]

For some reason, a query similar to this: " DELETE FROM `tablea` WHERE `id`=1; DELETE FROM `tableb` WHERE `id`=1; "Works fine when i run it directly on the mysql server. But if i run it through mysql_query() in my php function it fails... It should work, right?

[Synook]

The original mysql PHP library can only run one query at once. You need mysqli to run multiple ones at once like that.

[astralaaron]

The original mysql PHP library can only run one query at once. You need mysqli to run multiple ones at once like that.

thank you.

[Ingolme]

I'm not exactly certain, but I think this query probably would work:

DELETE FROM `tablea`,`tableb` WHERE `id`=1;