need help with simple delete (currently in 2 queries)

[jpfour23]

Hello,

Excuse my lack of understanding subqueries... but I can't figure this one out on my own. Currently I have two queries I am running, and I'm positive I can accomplish this in one query. Any suggestions?

First delete all emails that have a grp_id as "#".

  $del_emails_sql = "DELETE FROM enews WHERE grp_id='$_POST[radioID] AND siteID='$_SESSION[siteID]'";

Then delete the group id that = "#".

  $del_grp_sql = "DELETE FROM enews_grps WHERE id='$_POST[radioID]' AND siteID='$_SESSION[siteID]'";

Anyone? Thanks in advance.
JP

[Dan Grossman]

MySQL does not support subqueries prior to Version 4.1, or the use of more than one table in the DELETE statement prior to Version 4.0.

^

[jpfour23]

so really there's no way to do this outside of subqueries?

[Dan Grossman]

Just run two queries. Not that bad to have an extra line of code in your program.