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