Well off the top I'd say your forgot the join condition between the
fo_topics and the fo_forums tables.  Right now you're counting the Cartesian
product of the two tables.

Also you can't select an aggregate function (like count) and regular columns
without a group by on the same columns.


on 3/2/02 8:37 AM, [EMAIL PROTECTED] at

> From: "Andy" <[EMAIL PROTECTED]>
> Reply-To: "Andy" <[EMAIL PROTECTED]>
> Date: Sat, 2 Mar 2002 17:36:41 +0100
> Subject: Difficult count statement. Need some sql advice
> Hi there,
> I would like to querry my db for following result
> - Count the number of topics listed in the table fo_topics,
> but only the topics where the belonging forum is not in the archive  mode
> ( this is when table fo_forums field archive is 1)
> I tryed following querry but this is for sure wrong:
> SELECT COUNT(t.*) AS c, f.archive, f.forum_id
> FROM fo_topics t, fo_forums f
> WHERE f.archive != 1
> Can this be that difficult?
> Thanx for any help
> Andy

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to