Hello there,

I have a question in regards to mySQL is it possible to order a group of articles within another group of ordered articles?

For example.. say I have a catalogue of items, and each has the properties of date, and item_name.

in this mySQL database, for arguments sake, i have

id date item_name
1. 2001-4-5 Toothpaste
2. 2001-2-15 Soap
3. 2001-4-5 Hairbrush
4. 2001-2-15 Shaving Cream

What I would like to do, is to SELECT all the items from this database, and ORDER BY date in DESCending order, and then ORDER BY item_name, so I will end up with

3. 2001-4-5 Hairbrush
1. 2001-4-5 Toothpaste
4. 2001-2-15 Shaving Cream
2. 2001-2-15 Hairbrush

Is there a mySQL statement that can do that for me? Or would I have to go through each date then systematically grab each group of items according to the date.

Thanks for any help!
Ardi