Need a query to find the number of Friends members have
 

Hello all,

I am trying to find a query I can run that will output the number of Friends/Buddies members on my site have. Can someone please help with this?

Thanks,

Keith

Where are you wanting this to show up?

I just need to run it in the ACP to find the members with X number of Friends.

There's a field called "friendcount' in the user table, so maybe


although I haven't tried it. Of course "vb_" should be whatever your table prefix actually is, and "100" should be the id of the user you're insterested in.

Thanks kh99, that did tell me the number of Friends for the use entered, but what I'm looking for is a query that will output the usernames of members that X number of Friends or more. Sorry, I should have been more clear on my needs.

not sure whether this would work

select friendcount,username,userid from vb_user;

That did work, any way to sort the results from most to least Friends? Right now randomly displayed across 64 pages.

Use this:
Replace vb with your table prefix and change 100.

The query sulasno posted worked, I added to it to get it to sort the output by username with the most Friends first.

Thanks for everyone's help.

--------------- Added [DATE]1284190422[/DATE] at [TIME]1284190422[/TIME] ---------------

vB Style, yours worked as well allowing me to set the cutoff number for Friends.

I should have realized that you'd want to output more than the number, I just wasn't thinking.