order by date

[Bladerunner]

Hi,

my query is as follows:
$sql = "SELECT * FROM Calender WHERE idx = $widx ORDER BY cdate ASC"

cdate is a datetime field (example 2010-09-27 20:41:54)

But with this query the dates are not correctly ordered.
I get this as result back:

ma 27 sep 20:00
ma 4 okt 20:00
ma 11 okt 21:00
wo 10 nov 21:30
ma 25 okt 22:00
ma 18 okt 20:00 --> wrong

Can anybody help me with this?

[TobyRT]

what is idx? what is $widx?
what are you expecting to see?

[Bladerunner]

The fields of table Calender are as follows:
index widx hour cdate placeidx

the widx is just a reference to another table.
The only thing I want is that the records that I get back from the query are ordered by the cdate field in this table.

[TobyRT]

have you checked the actual data in the table, make sure it's not corrupted - it looks like your last two entries there are incorrect...

[Bonesnap]

What's the year on the dates? You're only displaying the month, day and time, but no year. Those results could very well be accurate if the last two rows' year is greater than the rest.