## Problem with ORDER BY

Hi! I have a database in PhpMyAdmin, linked to a php page where you can see all the information stored in the database inside a table. The problem is that the ORDER BY commands don't work as I would like.

For example, this query

Code:
`SELECT * FROM table WHERE conditions ORDER BY date`
doesn't order the entries in the right date order (date is the name of a column of the database). As a result I get something like this instead:

2010-10-10
2010-10-10
2010-10-25
2010-10-11
2010-10-08

I have the same problem with other ORDER BY commands (order by name in alphabetical order ecc.)

Am I doing something wrong?