Delete Problem
| From: | KPortsmout at aol dot com | Date: | Fri, 30 Mar 2001 12:14:58 +0000 |
| Subject: | Delete Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-46303@lists.php.net to get a copy of this message | ||
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