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


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

Reply via email to