Re: Delete Problem

In a message dated 30/03/2001 17:59:52 GMT Daylight Time, smasiello@chekinc.com 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 echod it out. Its 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