this is not answer of my question

[php4om]

Id Name rid

1 a 0
2 b 1
3 c 1
4 d 1
5 e 1
6 f 2
7 G 2
8 H 1
9 I 2
10 J 3
11 K 2
12 L 3
13 M 3
14 N 4
15 O 4
16 P 5

Here is a referrer table below “0” is the id of admin from where is starting.
What I want is to count top 5 referrer with names in ascending or descending order.
Can u help me please. I am new to php. I need code for this in php-mysql

Example Out put -
1. a = 5 total referrer
2. b= 4 total referrer
3. c = 3 total referrer
4. d = 2 total referrer

here it should be outupt depend on serveral records.

thanks

[gardnc]

Ok, here it is - not a foolish answer. Nobody knows what your want to knwo. Be clear, ask real questions that correcsond to your topic and request data. Good gosh, what do you expect?

[statusquo]

looking at your text file, there is no information about what is being referred or how many have been referred.....not to mention who referred what or who referred who 😕

See how confusing your question is?

What exactly do you need? Do you need the first five in the table listed? Do you need the 5 who referred the most listed? Where is the rest of the info coming from?

Post that and I'll bet you get a lot more help.