I am getting an error using fetch_object() in a SELECT statement with NOT IN Clause

i.e Say:

select 
  * 
from tblname 
where col1 NOT IN array;

have problem using NOT IN.... but no开发者_JS百科t when i do: col1 = 'singlevalue'; Please help

---

use select * from tblname where col1 NOT IN ('value1','value2',...,'valueX')

---

Post the code you have, this works (if I understood your question right):

select userid,username from users where userid NOT IN (1,2,3,4) limit 10

---

you should:

• format you code
• exactly describe what's you problem; if there's an error message, please post that message
• provide as much reasonable information as you can, so it's easy for us to see what you're trying to do

EDIT: some more points:

• show the error-message you're getting
• output the sql-statement that gets executed and try to execute it by hand (using phpmyadmin something similar)
• var_dump or print_r your result and see what you get - if it's false, think about what could be wrong: either your sql returns zero rows or there's a failure in it - just one of those two possibilitys
• if you get additional information, edit your question and list it there, don't force everybody to read every comment on every answer till now - you've given some information, but it's spread to everywhere
• fetch_object won't be the problem - the problem is, as said, either a result with zero rows or a bad statement

till now, this is just a comment, my attempt to answer your question (it's not realy clear whats your problem):

sounds like you havn't understood how NOT IN works and havn't looked at the documentation. you query should look like this:

SELECT * FROM tblname where col1 NOT IN (1, 2, 3);
             # values of your array here ^^^^^^^

to build that from an php-array, you could use implode or something similar.

EDIT: a very basic sollution could look like this (not that you should check the input to avoid sql-injection and such stuff):

// for simple numerical values
$sql = "SELECT * FROM tblname where col1 NOT IN (".implode(", ",$myArray).")";

// for strings
$sql = "SELECT * FROM tblname where col1 NOT IN ('".implode("', '",$myArray)."')";

---

You likely have a NULL in your "array". That will cause NOT IN() to behave in a way you don't expect. Check for that.

---

It would help to see your exact query to be sure, but NOT IN is not followed by an array. its followed by (a, b, c) comma delimited string within parentheses

$inString = "(" . implode(", ", $array) . ")"; //looks like ('val1', 'val2', 'val3')
$sql = "SELECT * FROM tblname WHERE col1 NOT IN $inString"

-=edit in response to comment--

$mysqli = mysqli( host, user, password, db);

$inString = "(" . implode(", ", $_SESSION['preferences']) . ")"; 
$query = "SELECT * FROM ABC WHERE ID NOT IN $inString"; 

$res = $mysqli->query($query);
$obj = $mysqli->fetch_object();

Do you have all of these steps? The issue is that 'false'->fetch_object() is no good. 'false' is whats returned when a query has an error or has no results. This appears to be because your query is bad.