ranking products?

[Yzakir]

Hello all of you,
I need some help as I am getting trouble while ranking products. I have a 'top ten' sellers output from a system. The CategoryRanking has a value of 1 - 10 for the top ten, with all other products having a value of 0. In some categories, we do not sell ten products in 30 days, so we could have only six products with a value different to 0. With only 6 products, it will display the six products as in the query I disregard all products with a value of 0 because the layout of the site is integral to having ten products displayed. Including the 0, I always get them mis-ranking. Ideally, I would like to show the first 6, then any 4 products with value 0. Any ideas?
thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Yadira]

SELECT CategoryRanking, Product
FROM yourtable
ORDER BY CategoryRanking DESC
LIMIT 0,10; -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --