Limit new products or bestsellers by date

[michael_s]

I corrected some errors in the previous upload for best_seller.php

Specifically, the clause {p.products_quantity = 1} was restricting the best sellers list to products whose stock quantity is equal to 1, the clause {p.products_quantity < 4} was measuring total stock, not quantity ordered for a given order, et cetera.

Also, though the date range restriction was working, the quantity sold was taken as total quantity sold for all time, not the quantity sold during the date period of the date range restriction. I fixed this too.

best_sellers.php now works as intended.

More...