mysql not in 数组_PHP Mysql NOT IN数组仅影响数组中的第一个结果

So I have a query to create an array of ID's that I do not want to be included in the data that populates my Select List. Both the select list and the array of excluded ID's are being pulled from a mysql database. The problem I am having is that when I echo out $exclude, it appears correctly in a comma separated list (1,2,3). However, when I attempt to add it in my NOT IN statement, it is only excluding the first number. I need it to exclude the entire array. Any ideas?

$excludeSql = "SELECT member_id FROM appointments WHERE joint_id = '$jointid'";

$excludeData = mysql_query($excludeSql, $link);

while($excluderow = mysql_fetch_array($excludeData)){

$excludearray[] = $excluderow['member_id'];

}

$exclude = implode(',',$excludearray);

echo $exclude;

?>

--Select--

$memberSql = "SELECT id, firstName, lastName FROM members WHERE id NOT IN('".$exclude."') && compid = '$compid' ORDER BY lastName ASC";

$memberResult = mysql_query($memberSql, $link);

while($memberRow = mysql_fetch_assoc($memberResult)){?>

解决方案

You don't need the quote here:

WHERE id NOT IN('".$exclude."')

^ ^

Also you could achieve the same result in one query:

SELECT

id,

firstName,

lastName

FROM members

WHERE id NOT IN

(SELECT

member_id

FROM appointments

WHERE joint_id = '$jointid')