At 1:44 PM +0100 8/21/01, Russ Michell wrote:
>  > I always love that feeling when you beat a problem that refuses to go away.
>So do I - but I aint beaten it yet! :-(
>
>I'm still getting '2' as being the number of posts in each category 
>when '2' is actually only the
>number of posts in *one* of the categories...weird-huh?
>

Try

SELECT category, COUNT(category) AS cat_count FROM postings GROUP BY 
category ORDER BY category

I find using the specific field you want count, instead of the count 
all fields changes the count results on occasion.

Alnisa
-- 
   .........................................
    Alnisa  Allgood
    Executive Director
    Nonprofit Tech
    (ph) 415.337.7412  (fx) 415.337.7927
    (url)  http://www.nonprofit-techworld.org
    (url)  http://www.nonprofit-tech.org
    (url)  http://www.tech-library.org
   .........................................
    Nonprofit Tech E-Update
    mailto:[EMAIL PROTECTED]
   .........................................
    applying technology to transform
   .........................................

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to