GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Saturday, April 9, 2011

SQL - A Little Complex

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";
Share/Bookmark

No comments:

Post a Comment