hello,
I have table which collects download informations like download date time, email,name etc.
Now I want to sort records by date in asc as well as desc order. Also i want to remove hours from download date.
I used date format of php but it does not work.

pls. help.
rakesh.

Your existing code would be helpful.

Select the datetime w/o hours through your query:

SELECT SUBSTR(date, 0, 10) as date_no_hours, ... (other fields) ... FROM download_table ORDER BY date;

Select the full datetime from your MySQL database and display w/o hours using PHP:

<?php
echo substr($query_result['date'], 0, 10);
?>

Or, if you want to get fancy and return the date in a more readable format for your users, take a look at the date() and mktime() functions