[RESOLVED] sorting dates

[PureDrive]

Hi, I have a timestamp field in one of my database (mysql) tables so that when I insert a new row, a timestamp is inserted as well via the mysql UTC_TIMESTAMP() function in this format "MM/DD/YYYY HH:MM:SS". I need to be able get the rows from the table and place them in an associative array of: $some_arr[$date] = $row['some_field']. array keys must be the dates from earliest one to latest. Is there a php/mysql function that can help me with this type of sorting. I want the code to be as efficient as possible and I really don't feel like using my sorting functions but rather a predefined php ones. Any suggestions? Thanks

[bradgrafelman]

If it's a TIMESTAMP column, you should be able to add an 'ORDER BY time_col DESC' to your SELECT query.

[PureDrive]

ok thanks bradgrafelman.

[bradgrafelman]

So did that resolve your issue? If so, don't forget to mark this thread resolved.