a to z list

[brown2005]

Hi,

I have a table called links

and i want to create a page where the links are ranked on the amount of times they have had hits...


i.e.


10000 hits

a.co.uk
b.co.uk

90000 hits

h.co.uk

any help please?

[ober]

Are the hits stored in the same table?

SELECT * FROM table XYZ order by hits

[brown2005]

sorry, yes they are in the same table as hits...

[ober]

So is the question answered?

[brown2005]

No, sorry let me tell you again, i havnt explained it properly....

instead of

alfa.co.uk--------------------1000
bravo.co.uk-----------------500
charlie.co.uk----------------400
cabbage.co.uk----------------400
dikkins.co.uk----------------200

i want them listed like;

1000
alfa.co.uk

500
bravo.co.uk

400
charlie.co.uk
cabbage.co.uk

200
dikkins.co.uk

[samshel]

I guess if you are talking of displaying , then it can be done with code on the front end. Something like this

[code]
<?php
//make db connection here

$query = "SELECT * FROM table XYZ order by hits desc";
$result = mysql_query($query) or die (mysql_error());
$num = mysql_num_rows($result);
$current_price = 0;
for($i=0;$i<$num;$i++) {
    $row = mysql_fetch_array($result);
    if($row['hits'] != $current_price) {
    echo $row['hits']."<br>";
    $current_price = $row['hits'];
    }
    echo $row['url']."<br>";
}
?>
[/code]

I have not tested this code, but should work.

hth