A little complex queries:
$q = "SELECT forum_topic.id, forum_topic.title, forum_user.username, forum_topic.date, forum_topic.time, count(forum_reply.tid) as 'count' FROM forum_user, forum_topic, forum_reply WHERE forum_user.id=forum_topic.uid AND forum_topic.id=forum_reply.tid GROUP BY forum_reply.tid";
No comments:
Post a Comment