Quote:
|
Originally Posted by jillsybte
86400 is the number of seconds in a day (60x60x24). So leave the 86400* and just change the 30 to whatever number of days you prefer; the result will be the number of seconds in that many days. If you simply replaced (86400 * 30) with 60, you would be basing your bestsellers on orders from the last minute only.
|
Sorry, I should have been more clear. I changed the 30 to 60 and 90 but the results never changed. I also have changed XC_TIME to time() with no luck as well.
I have also just noticed it is not getting the items correctly either. I know I sold 50 pieces of 3mm carbon in one order and 24 pieces of 1mm carbon but 1mm is listed first and 3mm 4th on the list. and some items don't show at all that should be.
It is getting late and tomorrow is another day.
Thanks, Mike