Mysql order by date

[Cyto]

Hello,

 

I would like to order by date that contains day and month, like this: 14-3

Is this possible?

 

  Quote

$sql = mysql_query("SELECT * FROM date WHERE online='1'");

[requinix]

Why aren't you using a DATE or DATETIME column?

[Cyto]

because i'm adding it from admin. See it as adding a event in a calendar.

[Psycho]

  Quote

because i'm adding it from admin. See it as adding a event in a calendar.

 

Huh? I'm not following. You should always store dates/times as appropriate date and/or time formats in the database. You can always convert the value into whatever format you want in the output.

[Cyto]

Is there a way to covert 14-3 to what you mean and order it?

[cpd]

  Quote

Is there a way to covert 14-3 to what you mean and order it?

 

Change the field type to DATE and alter your code to format the date as YYYY-MM-DD. Then either write a script to convert existing dates, even though you don't have the year :s, or do it manually (long).

[Cyto]

I founded out myself. Using  STR_TO_DATE(date, '%d-%m') ASC.