[thelist] MySql - checking two tables at once.

Martin Kuplens-Ewart martin at takingitglobal.org
Sun Jan 6 01:37:20 CST 2002


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






More information about the thelist mailing list