I want to put a top 3 links list at the top of mu category pages, sorted by hits. The links in the category must be sorted by aplha.

I followed all the instructions in:

http://gossamer-threads.com/perl/forum/showflat.pl?Cat=&Board=L2Cust&Number=39692&page=&view=&sb=&part=1&vc=1

I managed to put the top 3 in my category pages, however I cannot get the sort order right.

As karl said in the forum topic above:

" i use your mod and everything works fine, but the "ranking" is in wrong order.
There is no System in it, like the one with the most hits on top.

Also most of the entrys in the category are not shown.

As example:

1. Some Link (9 Hits)
2. Some Link (320 Hits)
3. Some Link (1 Hits)
4. Some Link (1 Hits)
5. Some Link (1 Hits)

But there are also entrys with 123 or 212 Hits, but there are not in the toplist. "

Eliot replied with:

"Yea...In Jerry's earlier post, he mentioned that you need to edit the sub build_sorthit routine in the db_utils.pl file.

Go to the following URL for information on what you need to edit the sub build sorthit routine:

http://www.widgetz.com/review/instructions.cgi?4"


Well the link above is dead!!!! And I cannot read a sololution elsewhere in this forum.

An example of what I want is shown at:
http://www.fussballsuche.de/de/Global/EM_und_WM/


Please Help me, because I spend too many hours already ...


Axel