Php clicklog/counter

[saikosys]

I'm making a site with a download page and a links page. I would like to add a counter after each file name, it must looks something like this:

Downloads:

- Song1.mp3 (3210 downloads)
- Song2.mp3 (21345 downloads)

Links:
- freewebspace.net (321455 clicks)
- google (2134563 clicks)

I found a lot of clicklog scripts at hotscripts.com and php.recourceindex.com but they all just log the click into either mySQL or a txt file. How can I get this info from a mySQL database or txt file to display on my html page (links.php or downloads.php)?

Any help would be greatly appreciated!!

 

[kabatak]

How can I get this info from a mySQL database or txt file to display on my html page (links.php or downloads.php)?

You get the data from the database then display them

 

[biggulp]

you'll need to give more details, like the column names...