Order by product and order by price

[afrika]

hi,
i have a products page, which is sorted according to alphabetical order.

Now i want to be able to order not just by product but also by price, because if i dont i have a senario such as

product price
product A 500
product A family pack 470
product A starter pack 450

Now from the above the product follows the alphabetical order. But the price structure is mixed up. I want it to be ordered ASC by prodcut and also ASC by price.

how do i achieve this ?

thanks
Afrika

[r937]

I want it to be ordered ASC by prodcut and also ASC by price.

... order by product, price

[afrika]

hi Rudy,
QUITE SIMPLE

Guess you are the database GURU here
Thanks for your continued assistance

rgds
Afrika