rashgang Posted June 10, 2013 Share Posted June 10, 2013 i am trying to query top 5 most viewed a item by users. how to create a table for this. should i calculate the views by viewed the product by user one time or many time. please someone help to solve this problem? Quote Link to comment Share on other sites More sharing options...
Barand Posted June 10, 2013 Share Posted June 10, 2013 Create a user_views table. When a user views a product, store id | user_id | product_id | timestamp That gives you ability to analyse by user, by product, by date and do things like "users who viewed that product also viewed ...." Quote Link to comment Share on other sites More sharing options...
Psycho Posted June 10, 2013 Share Posted June 10, 2013 . . . should i calculate the views by viewed the product by user one time or many time . . . That is completely up to you. It all depends on what information you are really trying to convey. Do you want to only show the number of views by unique users or for every view by every user? If the view count has any importance that users might be interested in then you might want to use views by unique users. Otherwise, users will try to "game" the system by refreshing the pages with the records for which they want to drive up the view counts. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.