Date Calcs - SQL or PHP

[jonnyboy]

I am building an application where I need to display the number of days since a post.

I know how to show a certain number of days of posts in the MySQL query, but not sure how to compare the date posted to today's date and display as number of days out standing - PHP or MySQL?

Any help greatly appreciated.

[LordShryku]

You can do either PHP or SQL.

MySQL Date and Time Functions
PHP's Date and Time Functions

[jonnyboy]

Sorry to be dumb, but I am struggling a bit.

I am not sure which option to go for in PHP? I found something in MySQL for version 4.1 however i am on 3.23 and don't want to change just now.

I need to do this...

mysql> SELECT DATEDIFF('log_stamp','CURRENT_TIMESTAMP');

bit can't in my version.

Any ideas???

Thanks

[jonnyboy]

Found answer...

TO_DAYS(date2) - TO_DAYS(date1)