Difficult count statement. Need some sql advice
| From: | Andy | Date: | Sat, 02 Mar 2002 16:36:41 +0000 |
| Subject: | Difficult count statement. Need some sql advice | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17415@lists.php.net to get a copy of this message | ||
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