[PHP-DB] 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

Re: [PHP-DB] Difficult count statement. Need some sql advice

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