ryel01 Posted June 13, 2008 Share Posted June 13, 2008 hi - I've got the following existing query, and I want to add another part to it which finds the user id (link_uid) of the person who has made the most posts (link_id) and have that value returned as "cat_top_poster". Can anyone help with that one? Thanks, regan. $sql = "select count(distinct link_uid) as cat_unique_authors, count(*) as cat_total_messages, max(link_date) as cat_latest_date from messageboardlinks where link_id IN ($lids) or link_father_id IN ($lids)"; Quote Link to comment https://forums.phpfreaks.com/topic/110017-select-to-find-user-with-most-posts/ Share on other sites More sharing options...
fenway Posted June 13, 2008 Share Posted June 13, 2008 Forget about adding another part -- write this separate query first. Quote Link to comment https://forums.phpfreaks.com/topic/110017-select-to-find-user-with-most-posts/#findComment-564775 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.