Hard mysql query??

[Anon]

Hi i want to set up an toplist over the most sold products from last week in my webshop. What i have done until now is that i have set up an table with the item id, time, and number of items. This table is beeing updated every time someone submits an order.

So the question is how do i set up a query to get the 10 most sold products from last week??. The date thing i think i can manage, but the problem is that i think i have to do some mathematics. Is this possible to do directly in the query??.

What i eventually would like to do is to compare this result with the result from the week before, to see the "movement" on the toplist (like Amazon.com), and maybe use some icons to show for it

Hope someone could help me with this.

Thanks in advance.

Tom

[Anon]

I don't know exactly what you mean by putting a little mathematics in it, but I used this myself:

SELECT * FROM products WHERE time>$begin_this_week AND time<$begin_next_week ORDER BY sold DESC;

If you be more specific on your 'methematics' problem, I might be able to help you out. Otherwise, the above should do, I guess.

Greetz,

Vincent Driessen
Venlo, The Netherlands