page / product clicks ?

[Girish]

Hi

I have list of products listed from a search criteria, Now I wanna show the
client TOP VIEWED LIST OF PRODUCTS or number of hits for each product. So
the page hits using the counter component will give me the hits for the
entire which has all the products.

Perhaps I could catch it in the product DETAIL page, how do I list the
number of hits for each product. Secondly I have IIS 4.0 make sure you
recomend the right component.

Thanks much!

 

[Manohar Kamath [MVP]]

Store the clicks for each product in say product table. When user clicks on
the product detail page, update this count -- use a stored proc/method to do
this.

There are multiple ways of doing this, but my generic statement is because
of lack of details on your application. Hope that helps.

 

[Girish]

I got the idea of updating once you get detail page by setting an increment
counter (say x) like Update table name set x=x+1 where
productid=request(id), how do I store the clicks? I guess I need to insert
one record for each unique product setting x = null or zero.... right?

Please tell me how would you do it, feel free to ask me specifics.

Appreciate it.