Confusion!

[stereo]

I have a fav member system on my site. When a member adds another member to their list, the member they add get's entered into a table, along with every other member that get's added. Right now im making a facts page, and need to select the member with the most entries into that table so I can say that they are the most popular member. Problem is I am a bit confused and don't understand how I can do it.

Can someone help me please?

Stereo

[[deleted]]

If you are entering the same username or userid into the table several times, you can count then using SQL's count() function.

SELECT id,name,count(*)
FROM table
GROUP BY id;

this will group all records together based on the id (you could also use the name)
so records with the same id form a group.
The count(*) then counts how many records there are in each group.

[stereo]

Okay, so would this work..........?

$result = mysql_query("SELECT username, Count(*) FROM Online GROUP by ID;");

while($r = mysql_fetch_array($result)) {

$User = $r[username];

The value of $User should give me the member with the most entries, am I right?

[[deleted]]

Almost, you should change the "count()" into "count() as cnt"
That way you can get the result as $r['cnt']

And ofcourse the result would be in $r['cnt'], not in $r['username']