In a message dated 30/03/2001 04:42:44 GMT Daylight Time,
[EMAIL PROTECTED] writes:
<< What doesn't work and where is your delete statement?
>>
This is my full code
$www_domain="select Failed_Signups.EmailAddress.Email from
Failed_Signups.EmailAddress left join www_domain_net.Members on
Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
www_domain_net.Members.EmailAddress is null";
$www_domainRESULT=mysql_query($www_domain);
$www_domain_rows=mysql_num_rows($www_domainRESULT);
for ($a=0; $a<$www_domain_rows; $a++)
{
mysql_data_seek($www_domainRESULT, $a);
$www_domain_Array = mysql_fetch_array($www_domainRESULT);
printf("%s", $www_domain_Array['Email']);
$inlist .= sprintf("\'%s\'",$www_domain_Array['Email']);
}
$query = mysql_db_query("Failed_Signups","DELETE FROM EmailAddress WHERE
Email NOT IN (".$inlist.")");
Ade
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
