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]
