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]