Re: [PHP] Delete Problem

2001-03-30 Thread Christian Reiniger 

On Friday 30 March 2001 14:14, you wrote:
 echo"$inlist";
 $query="DELETE FROM EmailAddress WHERE Email NOT IN $inlist";

$query="DELETE FROM EmailAddress WHERE Email NOT IN ($inlist)";

-- 
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)

Even idiots can handle computers, and many do.

--
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]

RE: [PHP] Delete Problem

2001-03-30 Thread 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]

Re: [PHP] Delete Problem

2001-03-30 Thread KPortsmout 

In a message dated 30/03/2001 17:59:52 GMT Daylight Time, 
[EMAIL PROTECTED] writes:

 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')" ;
  


Yeah, this code puts the email address`s into a comma seperated list

$inlist .= sprintf("%s", $www_domain_Array['Email']);
if($a  $www_domain_rows - 1) {
$inlist .= ", ";

That bit works ok as I have echo`d it out. It`s just the final delete that 
wont work :/

Ade

PS: I tried wrapping $inlist to ($inlist) in my delete statement as suggested 
but that didn`t work either

-- 
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]