I have a page where user has to input date. from there i have a script that covert the number inputted using mktime() and insert the time created to the databse. Now the question is is there i way i could select data from my database in descending or asc order with field date as the index?

$sql = mysql_query("SELECT * FROM table ORDER BY date_field_name DESC");

If you don't specifiy DESC on the end, it will ORDER ASC as default.

as in your title basically

ORDER BY datecolumn ASC | DESC

ORDER BY