On Sat, Mar 02, 2002 at 05:36:41PM +0100, Andy wrote:
> 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

You need to join the two tables together:

select count(t.*) as c, f.archive, f.forum_id
from fo_topics t, fo_forums f
where t.forum_id = f.forum_id and f.archive != 1

might work. I assume you have a foreign key in fo_topics linking to fo_forums.


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

Reply via email to