Organize Content by Date PHP And MySQL

[tgmd]

I have a Mysql data base. I have several entry's that are all organized by time (standard way mysql inserts it, it looks something like 20060711123751 (year, month, day, hours, minutes, seconds) all in one string. Now I need to print all of these out (let's say there's three of them) by date (earliest one first). I need to know if there's a PHP or Mysql funtion for this.

Any help would be greatly appreciated

thanks in advance.

[meman1188]

i don't know of a way to do it in PHP, but you can ORDER your mysql query and have it return the dates in any order you like.  Hope this helps.

ex query: SELECT *  FROM `table` ORDER BY `DATE (field)` ASC

-- Brady