August 1, 201115 yr Hi, I am wanting to select 5 products from my catalog that are the most viewed. Can anyone advise. Many thanks in advance
August 1, 201115 yr Do you track views each time? If so, just select with a limit of 5 ordering by the viewed field descending
August 1, 201115 yr Author Do you track views each time? If so, just select with a limit of 5 ordering by the viewed field descending na i havnt tracked at the moment, im not sure how to do it? Cheers Craig
August 1, 201115 yr Either add a field to the product table, or create a new table that links to the product id, that also has a field that you can increment. Then when the page is requested for a product, increment value of viewed by one
Create an account or sign in to comment