<div>
<div class="content wysiwyg-content">
I am looking for help on sorting dates with mysql. Here is a query that I am working with:<br />
$result = mysql_query(&quot;select * from shows ORDER by showdate&quot;);<br />
<br />
This is working but not as I need it to. Here is a sample date systen I want to use:<br />
month.day.year<br />
03.17.04<br />
08.13.04<br />
11.14.04<br />
01.23.05<br />
<br />
How can I set up mysql to work with this date system? Note - I am working with PHPAdmin so if you can speak to me in that lingo it would be helpful because I am not fully versed with mysql command prompt. Also does it matter if I use &quot;/&quot; or &quot;.&quot; to separate the month.day.year<br />
<br />
Thanks<br />

</div>
</div>


I am looking for help on sorting dates with mysql. Here is a query that I am working with:
$result = mysql_query("select * from shows ORDER by showdate");

This is working but not as I need it to. Here is a sample date systen I want to use:
month.day.year
03.17.04
08.13.04
11.14.04
01.23.05

How can I set up mysql to work with this date system? Note - I am working with PHPAdmin so if you can speak to me in that lingo it would be helpful because I am not fully versed with mysql command prompt. Also does it matter if I use "/" or "." to separate the month.day.year

Thanks


Sort date style month.day.year

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.