Do you remember the post I wrote about How to calculate relative time like facebook?
The code was a little bit messy so today i'll show you a short snippet.
In my example I have stored the time in a datetime field in my MySQL database.
Then I'd like to know how many days ago was it.
Code language: PHP (php)
// $my_database_field coud be -> "2011-06-04 09:52:01" $days_ago = (time() - $my_database_field)/86400;
Easy, right? 😉