select to find user with most posts

[ryel01]

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)";

[fenway]

Forget about adding another part -- write this separate query first.