[Resolved] Is there a query that can do this?

[ehask]

Hey Everyone,

Ok I had a function that kept track of the articles in a table (number of them)

Well I now modified my code and made 2 new categories Where I put all the code to populate the website (home,About,Contact and so on)

I want to still have a function to count the actual articles on the site
old code was "Select id from articles"

Now I need to restrict it from counting in articles in two different category id's. Is it possible in a query to tell it not to select where category = '1' and category = '2' ?

If not I guess I can write a new query to select the Site page articles count them and deduct from first query.

Thanks for any tips Been all over mysql.org site.

Eric

[nemonoman]

Select id from articles where category = 1

[ehask]

I know how to select one category id ...what I want to do is

"Select id FROM articles WHERE id != 1 or 2"

mysql_num_rows($blah)

So it would say select category id's 3 thru 10 and final result
would tell me there were 8 articles

I know that is not the correct syntax but basically what I am looking to do

[nemonoman]

Time to RTFM.

Select id FROM articles WHERE id NOT IN (1,2)