problem using foreach and implode functions

[needs_upgrade]

Hello guys!

 

I want to make a query like this:

SELECT service_id FROM services WHERE service_id NOT IN ( 4, 6, 8, 12)

but the values in the "NOT IN" clause will be taken from an array from a group of checkboxes. This is my code:

 

<?PHP
$pid_array = $_POST[pid];

$sql = 'SELECT service_id FROM services WHERE service_id NOT IN (';
foreach ($pid_array as $service_id) {
     $sql .= "".implode(", ", $service_id)."";
}
$sql .= ')';
mysql_query($sql);
?>

 

It says : Warning: implode() [function.implode]: Invalid arguments passed

Thanks guys

 

[teamatomic]

implode wants an array not a string. Your foreach loops an array giving a string each loop. skip the foreach and feed implode the pid array.

 

 

HTH

Teamatomic

[needs_upgrade]

ok. i'll try that. thanks teamatomic