reffrer problme urgently required

[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.

[justsomeone]

Assuming you use mysql, read up on the "group by" clause in the "select" command.

[php4om]

i am not getting the idea am new to php can u solve this problem group by is not counting total.

i just want total how many time id 1 or 2 or 3 or 4 or 5 have been repeted. just till top 5 levels.

thanks
in advance

[gkelly]

This should do the trick.

$query="select name, rid from your_table order by rid desc limit 5";

$result=mysql_query($query);

while($row=mysql_fetch_array($result))
{
echo "$row[name]=$row[rid] <br>";
}

However if you have the same name on multiple records then you want your query to be the following.

$query="select name, coutn(rid) as 'rid' from your_table group by name order by rid desc limit 5";

~Eugene Kelly

[php4om]

Here in this problem gkelly has told it does not solve my purpose.
I think gkelly has written this code for some thin else.
what I want is – I want to all count id like id 1 name a is repeated 5 times.
Similarly id 2 is repeating 4 times.
Id 3 is repeating 3 times. Here is the example.

No. id Name total
1 1 a 5
2 2 b 4
3 3 c 3

Like this table - a has 5 childs, b has 4 Childs and 3 has 3 Childs.

Please check the above table. Please read carefully.

Thanks

[bradgrafelman]

First of all, what is your native language? Is English your primary language? I am in no way trying to make sarcastic remarks or offend your nationality; I merely wondered if you're English was a bit confusing simply because it is not your primary language. If it is, however, I would suggest proofreading your posts!

Are you saying you have the column 'total' in your SQL table? If not, why not add that, so that each time the script adds a row for 'a', you could have a "totals" table that would be updated each time?

At any rate, I'm a bit rusty on SQL, and I don't know that I understand you entirely, but I believe I could solve your problem by doing something like this:

$query = "SELECT COUNT(rid) AS total, name, rid FROM referrer GROUP BY name ORDER BY rid DESC LIMIT 5";
$exec = mysql_query($query) or die('Error, MySQL said: ' . mysql_error());

$i = 0;
while($result = mysql_fetch_assoc($exec)) {

echo 'Referer #' . $i . ': ' . $result['name'] . ' has ' . $result['total'] . ' hits.<br>';

$i++;

}

I BELIEVE this is what you are asking for. It will count how many times a 'name' is repeated (returned as the 'total' column) and order the results by 'rid'. The output would be something like:

Referrer #1: a has 6 hits.
Referrer #2: b has 5 hits.
Referrer #3: c has 4 hits.
Referrer #4: d has 3 hits.
Referrer #5: e has 2 hits.

[gkelly]

You need to make questions clear if you hope to get them answered!

~Eugene Kelly

[php4om]

I am very sorry but output is still not correct.
bradgrafelman has written a code but it is not showing correct output as he is given one output bottom of the post.

Output from the code looks like this by bradgrafelman code.
Referer #0: n has 1 hits.
Referer #1: o has 1 hits.
Referer #2: p has 1 hits.
Referer #3: v has 1 hits.
Referer #4: w has 1 hits.

Again I want to clear what I want exactly.
I have a table referrer. This referrer table contains a “rid” which is coming from id field
I have to count how many times id is in all rid field.

Thus output should like this.
1. a 5 (a is repeating 5 times in all row )
2. b 4 (b id is repeating 4 times in all row )
3. c 3 (c id is repeating 3 times in all row )
4. d 7 (d id is repeating 5 times in all row )

Please see the attachment table.

[bradgrafelman]

I'm sorry... but I'm still confused on where the 'rid' field is coming from. I'll make another attempt at finding what you want...

$query = "SELECT COUNT(name) AS total, name, rid FROM referrer GROUP BY name ORDER BY rid DESC LIMIT 5"; 
$exec = mysql_query($query) or die('Error, MySQL said: ' . mysql_error()); 

$i = 0; 
while($result = mysql_fetch_assoc($exec)) { 

echo $i . '. ' . $result['name'] . ' has ' . $result['total'] . ' hits.<br>'; 

$i++; 

}

[php4om]

This is just reffrer program "rid" is comming from id fields when somebody register through some reffrer id that is also inserted in rid field.
i am very sorry no body is getting what i mean to say. in this reffrer program. Well out pot is not what is my need.

here is the out put of the last program.
0. n has 1 hits.
1. o has 1 hits.
2. p has 1 hits.
3. v has 1 hits.
4. w has 1 hits.

[php4om]

hi
this is not working, can u tell em plz what wil be the query?
thanks.