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)"; 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. 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
Archived
This topic is now archived and is closed to further replies.