MySQL PDO "NOT IN" statement returning wrong count

Asked Aug 01 '15 at 14:19

Active Aug 01 '15 at 15:00

Viewed 21 times

I'm trying to return the members who's ID's aren't on the list provided in the MySql statement.

Heres the members table:

--------------------
| ID | Member Name |
--------------------
|  1 | John Smith  |
--------------------
|  2 | Larry Brown |
--------------------
|  3 | Jim Gray    |
--------------------

Here is my query statement:

$entries[':list'] = "1,2,3";
$mQuery = $this->db->prepare("SELECT * FROM members WHERE ID NOT IN (:list)");
$mQuery->execute($entries);
$mTotal = $mQuery->rowCount();

$mTotal should be returning 0 but instead is returning 3. Can anyone explain why?

edited Aug 01 '15 at 15:00

asked Aug 01 '15 at 14:19

SReca

dont you have to pass in second parameter with the object to prepare – amdixon Aug 01 '15 at 14:23
http://php.net/manual/en/pdo.prepare.php You can pass in a second param but its optional not required. Are you suggesting I should? – SReca Aug 01 '15 at 14:29
surely this should be `$entries[':list'] = "1,2,3";` – Professor Abronsius Aug 01 '15 at 14:29
@RamRaider you're right, but still have the same results. – SReca Aug 01 '15 at 14:33
3

see [binding-parameters-for-where-in-clause-with-pdo](http://stackoverflow.com/questions/7044144/binding-parameters-for-where-in-clause-with-pdo#answer-7044270) – amdixon Aug 01 '15 at 14:35
@amdixion that was it! Thanks so much. Do you want to answer the question with your comment so I can mark it as the answer? – SReca Aug 01 '15 at 14:46
it's a duplicate and was closed as such. additional answers to duplicates shouldn't be submitted, that's basically how Stack rolls. – Funk Forty Niner Aug 01 '15 at 14:55

MySQL PDO "NOT IN" statement returning wrong count

0 Answers0