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.
$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.