ORDER BY question in mySQL

[Anon]

Hi,

I wish to a order a list firstly by the date and then by a name.

With ORDER BY date I get the following:

date name
2001-03-01 nathan
2001-03-01 graham2
2001-03-01 nathan
2001-03-01 graham2
2001-04-11 nathan
2001-04-11 graham2
2001-04-11 nathan

How do I get the rows to come out like this?

2001-03-01 nathan
2001-03-01 nathan
2001-03-01 graham2
2001-03-01 graham2
2001-04-11 nathan
2001-04-11 nathan
2001-04-11 graham2

Please help!

Nathan

[Anon]

May be, I don't understand smth, but what you need is:
ORDER BY date, name

I'm sure that's it :-)

[Anon]

Try
ORDER BY date, name DESC

THis should work ;-)
Chanderjit

[Anon]

Thanx people greatly for your help.