Sql Count Query
i have the following query
$sql = "SELECT count(article_auther_user_id) as number_of_posts, mi_users.user_name, mi_users.user_id FROM mi_article, mi_users WHERE mi_users.user_id = mi_article.article_auther_user_id GROUP BY article_auther_user_id ORDER BY user_name DESC";
Basically what i want it to do is to count the number of "article_auther_user_id" which is in the "mi_article" table, then match that info to mi_users table and return the user_name.
Can someone please help me out.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)