saj

hi

got another Mysql question sorry for the bother

right this is the scenario

i have the following fields on my table

prod_id, prod_description,prod_title,link,counter

the link is something where the user clicks on the link and it takes the user to another page.......

now what i want to do..is on the right hand side of my site i would like to display the top 10 products..this is based from the most clickable links!

So basically what needs to be done..is that say i have 5 products in the database

walkman
printer
scanner
mobile phone
mouse

say the Printer link is clicked the most..then this will appear on top of the "top 10"

Basically how do u increase the value of count to + 1 each time link is clicked

any ideas?
see

http://www.patsfreestuff.com

what i need is that on the right hand side..it will show the 10 most clicked product..

regards
Sajid

saj

sorry wrong forum
cud it be moved to scripting?

[mod edit]
Moved