[RESOLVED] Problem date ordering

[QuizToon]

Hi all

I am back to the best php help forum on the web, you never fail to sort me out, so here goes again.

Having a small problem with the following piece of code. I am trying to display my list in date order. Although it is doint in the correct number order it isnt taking into account of the month. Therefore 13 novemebr is showing above 28 October. How do i make it show correctly

$query = "SELECT id, event_title, event_text, DATE_FORMAT(event_date,'%D %M %Y') as event_date FROM events ORDER by event_date ASC"; 
$result = mysql_query($query) or die("Query failed: $sql - " . mysql_error()); 

Thanks in advance

[MarkR]

Assuming event_date is a datetime column, the above code should work.

Unless, that is, your code which puts dates IN to the database has been putting in rubbish data. If that is the case, your DB contains junk and needs to be fixed.

Mark

[QuizToon]

Thanks for the swift reply, not really sure i follow that. The information in the database is correct as far as i can see, although it has to be entered in the format yyyy-mm-dd, which seems odd to me but as I dont know how else to do it

This is part of the code for the user input

<input name="event_date" type="text" id="event_date" value="" size="55">

This is the code i am using to add to the database:

$database = mysql_connect($dbhost,$dbuser,$dbpass) or die("Could not connect to server");
mysql_select_db($dbname) or die(mysql_error());
mysql_query("INSERT INTO events (id, event_title, event_text, event_date) VALUES('','$title','$text','$date')") or die(mysql_error());

Thanks again

[QuizToon]

Oh meant to say that the event_date field in the database is set as date in the structure of the table

[QuizToon]

If anyone is interested, I have found the answer

... ORDER BY events.event_date DESC ...