[PHP] Delete Problem

[KPortsmout]

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]