Delete Multiple records

["Prellyan Luxtintner"]

Hey there,

 This is the stock code from DMX being a delete record from one table

 if ((isset($_GET['recordID'])) && ($_GET['recordID'] != "")) {
   $deleteSQL = sprintf("DELETE FROM sitedata WHERE siteid=%s",
                        GetSQLValueString($_GET['recordID'], "int"));

   mysql_select_db($database_bcmain, $bcmain);
   $Result1 = mysql_query($deleteSQL, $bcmain) or die(mysql_error());

   $deleteGoTo = "index.php";
   if (isset($_SERVER['QUERY_STRING'])) {
     $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
     $deleteGoTo .= $_SERVER['QUERY_STRING'];
   }
   header(sprintf("Location: %s", $deleteGoTo));
 }

 but how can i make that delete from 3 tables simultaneously?

 the other tables being 

 $deleteSQL = sprintf("DELETE FROM sitedata WHERE siteid=%s",
                        GetSQLValueString($_GET['recordID'], "int"));

 AND 
 $deleteSQL = sprintf("DELETE FROM sitecomment WHERE siteid=%s",
                        GetSQLValueString($_GET['recordID'], "int"));

 AND
 $deleteSQL = sprintf("DELETE FROM sitetag WHERE siteid=%s",
                        GetSQLValueString($_GET['recordID'], "int"));

 I hope that makes sense

 Thanks