[thelist] MySql - checking two tables at once.

[Martin Kuplens-Ewart]

To delete it from both tables... 

Try the following:

<snippet>

$dbh=$db->do("DELETE FROM tblAdvise, tblEmails WHERE
tblAdvise.Email = tblEmails.Email AND
tblEmails.Email='".sqlEncode($form{'EMAIL'}) ."' ");

</snippet>

That should do the trick in one delete

-m