I have a page where all the products get drawn from the database the sql query looks like this

SELECT *
FROM ProductsQRY
WHERE ProdPriceGRP = 'User' AND Type = 1 AND ProdMenu = 'Menu' AND ProdQuantity = 0

the problem is that i now want to repeat the same record over and again but into columns where the Prodquantity doesn't equal 0 so I get all of the quantity disscounts showing,

how should I do this?

// Leon