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? Link to comment https://forums.phpfreaks.com/topic/278991-how-to-select-top-5-most-viewed-a-category/ 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 ...." Link to comment https://forums.phpfreaks.com/topic/278991-how-to-select-top-5-most-viewed-a-category/#findComment-1435162 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. Link to comment https://forums.phpfreaks.com/topic/278991-how-to-select-top-5-most-viewed-a-category/#findComment-1435165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.