Query exclusion problem

[Sonic_Rage]

I'm trying to display the latest 5 topics in a forum, but there are 2 forums I do not want to be shown since they are moderator and admin forums. When I try to exclude them in the query, only one gets excluded. I haven't been able to figure out how to get forum 15 & 3 to not show.

$query = "SELECT topic_id, topic_title, topic_views from realm_topics WHERE forum_id !=15 && 3 ORDER BY topic_id desc LIMIT 5";

[cgraz]

Let me guess. 15 is the one not being shown, 3 still appears? Your query is just written inproperly. Try either of the following; they both work.

SELECT topic_id, topic_title, topic_views from realm_topics 
   WHERE forum_id NOT IN('15','3') 
 ORDER BY topic_id desc LIMIT 5

or

SELECT topic_id, topic_title, topic_views from realm_topics 
   WHERE forum_id !=15 AND forum_id !=3 
 ORDER BY topic_id desc LIMIT 5

Cgraz

[rupertbj]

&& !=15 && !=3

[Sonic_Rage]

Ok great, that works. Thank you for your help.:-)