--
Chris Bruce [EMAIL PROTECTED]
Idextrus E-Business Architects http://www.idextrus.com 3282 Wilmar Cres. Mississauga, ON L5L4B2 CA 905.828.9189 On Jan 30, 2004, at 12:54 PM, John W. Holmes wrote:
From: "Chris Bruce" <[EMAIL PROTECTED]>
Mysql 3.23.54.
My first thought was to load the output from the tables into an array and they use a foreach and in_array to create a list of dups, but I wanted to see if there was an easier way.
Ah, in that case, my other query won't work. :)
This should:
<?php
$query = "SELECT list1.email FROM master_list, list1 WHERE master_list.email
= list1.email";
$result = mysql_query($query) or die(mysql_error());
while($r = mysql_fetch_assoc($result))
{ $email_list .= "'{$row['email']}',"; }
$email_list = substr($email_list,0,-1); //remove last comma
$query = "DELETE FROM list1 WHERE email IN ($email_list)"; $result = mysql_query($query) or die(mysql_error()); ?>
Repeat for other tables.
---John Holmes...
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
