[MySQL] Confronto tra tabelle e DELETE

[marco80]

fai una select sulla seconda(email da eliminare)

$select = "select email from tabella1 ";
$query = mysql_query($select);
$array_email = array();
while($result = mysql_fetch_array($query)){
$array_email[] = $result['campo_email']
}

foreach($array_email as $email_delete){
$delete = "delete from tabella2 where campo_email = '".$email_delete."'";
$q = mysql_query($delete);
}