How to while click the link button Show frequently view product history?
For Example 1: Samsung,Nokia,Lava like that i want show which product mostly view Customers in that product.
Example our c-sharp corner also how many developer view the particular questions view count is there i want same concepts coding.
Please Send me With Example.
Loading
SenthilkumarPosted Mar 29, 2012, 12:09 AM
In the page load of preview product page, you need to store the hits.
S.No UserID ProductID IPAddress ViewedDate
1 25 45 120.12.1.0 3-3-2012
2 23 46 120.122.3.4 4-3-2012
When the user refresh again and again then you can avoid the duplicates by checking the details.
SELECT TOP 5 ProductID, COUNT(ProductID) FROM ProductsView
GROUP BY ProductID
Then you will get the maximum viewed top 5 products.
Other than this, you can use the google script to see the page views.
SenthilkumarPosted Mar 29, 2012, 12:38 AM
ViewedDate DATETIME DEFAULT GETDATE()
If you give like this then it will automatically update the date and time when you do insert and update.
magesh manavalanPosted Mar 29, 2012, 12:30 AM
magesh manavalanPosted Mar 29, 2012, 12:26 AM