Showing difference between now() and a stored date in Mysql Table
Posted on 2006-07-22
Got a 500 point question to the first buckeroo who can help me out here. Should be easy for some php pro; here goes:
Every time I "update" a record it updates a column called 'upgrade_time' with UNIX_TIMESTAMP()+1000, this works fine.
When I display the time 'till next upgrade, I want to show the time remaining between now() and whatever value is in upgrade_time in this format: days:hours:seconds. Can you show me how to do this?