codice:
$query1 = "SHOW TABLES as tabella";
$result1 = mysql_query($query1);

if($result1) {

  while($row1=mysql_fetch_array($result1)) {
     $query2 = "DELETE FROM ".$row1[0]." WHERE email='".$email."'";
     mysql_query($query2);
     

  }

}
dovrebbe andare, ma controllalo...