im working on a project repoting.database have almost up to 50000 records in a table. in this project i need to sort out records by days or month or by year. but problem is every recods have a column "addtime" there time() has been stored when record enterd.

i checked and with date("d/m/Y",$records['addtime']) working fine. but how i can show by day or year and month below is my code please help its very importent and urgent.

$result = $sm->queryfnc("select * from {tbl}authors where status=1 and YEAR(addtime)=2011", 'Get Result');
$rows = $sm->rowsfnc($result, 'Get Rows');
if($rows>0){
while($records = $sm->recordsfnc($result, 'Get Records')){
echo date("d/m/Y", $records['addtime']).' <br>';

}
}

Thanks in advance for your attention

__________________
Reputation is for time; character is for eternity.

You can use sql time functions to do this something like:

I am not sure what do you refer by sorting of day, because there is days of the month, days of the year, and days of the week. But you can do it from mysql without doing too much work in PHP. Just choose the documentation of the right version of MySQL that you are using, even though they don't differ much from version to version, but just to be safe.

I had something similar to do. I have used a php class to do calculations on time :
http://www.phpclasses.org/package/46...m-formats.html