PDA

View Full Version : Can't remember the clause


Logikos
06-11-2005, 11:55 AM
I can't remember the CLAUSE condtion but heres what i'm trying to do;



$db->query_read("
SELECT title, id
FROM tablename
WHERE id NOTIN(1,2,3)
ORDER BY title
");


Is that right? I want to exclude some ids but get the rest. So if i have.
"1 2 3 4 5 6" That query will get 4,5,6.

AN-net
06-11-2005, 01:44 PM
its NOT IN

Logikos
06-11-2005, 01:56 PM
Damm space! This whole time im going nutz over a space. I thought i was going crazy. Thanks AN-net!