RE: [PHP] Delete Problem

[Sam Masiello]

Correct me if I am wrong, but I thought that using IN needed to be followed
by a comma separated list (with each value individually separated from the
others) like this:

$query="DELETE FROM EmailAddress WHERE Email NOT IN ('value1', 'value2',
....., 'value_n')" ;

if you want to use a comma separated list, you can use the find_in_set
function:

$query="DELETE FROM EmailAddress WHERE !find_in_set(Email,
'value1,value2,value3, ....,value_n') " ;

HTH

Sam Masiello
Systems Analyst
Chek.Com
(716) 853-1362 x289
[EMAIL PROTECTED]

 -----Original Message-----
From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent:   Friday, March 30, 2001 7:15 AM
To:     [EMAIL PROTECTED]
Subject:        [PHP] Delete Problem

Hi,

Can anyone see a problem with this?


<?

$dbase="Failed_Signups";
// Connect to MySQL
$Connect=mysql_connect("", "", "");

$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++)
    {
    $www_domain_Array = mysql_fetch_array($www_domainRESULT);
    printf("%s", $www_domain_Array['Email']);
    $inlist .= sprintf("%s", $www_domain_Array['Email']);
if($a < $www_domain_rows - 1) {
    $inlist .= ", ";
}
    }
echo"$inlist";
$query="DELETE FROM EmailAddress WHERE Email NOT IN $inlist";
$query1=mysql_db_query($dbase, $query) or die("Problem1");

// Close MySQL Connection
mysql_close($Connect);
?>


It keeps stopping on $query1

thanks
Ade

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]