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 Link to comment https://forums.phpfreaks.com/topic/226908-x-minutes-ago-or-x-hours-ago-from-a-mysql-entry/ 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 Link to comment https://forums.phpfreaks.com/topic/226908-x-minutes-ago-or-x-hours-ago-from-a-mysql-entry/#findComment-1170816 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? Link to comment https://forums.phpfreaks.com/topic/226908-x-minutes-ago-or-x-hours-ago-from-a-mysql-entry/#findComment-1170832 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.