davidknag Posted February 6, 2011 Share Posted February 6, 2011 so i have a mysql column with a datetime and i was wondering how i could make it echo the time in "X minutes ago" or "X hours ago" and also, when its more then 24 hours old, delete the entire entry Quote Link to comment Share on other sites More sharing options...
litebearer Posted February 6, 2011 Share Posted February 6, 2011 This should get you thinking in the right direction... http://stackoverflow.com/questions/981262/how-do-i-subtract-using-sql-in-mysql-between-two-date-time-values-and-retrieve-th Quote Link to comment Share on other sites More sharing options...
davidknag Posted February 6, 2011 Author Share Posted February 6, 2011 Hmm could you show me a php example of this if its nots a big issue? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.