Try printing out $inlist and see if this is correct. Each item must be
separated by commas and it looks like your code may not be doing that.
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 11:58
Subject: Re: Delete Again?
> 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
