phpretard Posted August 9, 2008 Share Posted August 9, 2008 I have to field in a database. one is 08-08-2008 and the other is 08-08-2009. Tommorow their will be so many days left until the to meet. Is their some code that can print a count down? For Instance: 08-08-2009 minus Tomorrow = 364 day remaining I am truly clueless on thus one. Any help? Quote Link to comment Share on other sites More sharing options...
DarkWater Posted August 9, 2008 Share Posted August 9, 2008 Are they stored as a DATE column? Quote Link to comment Share on other sites More sharing options...
phpretard Posted August 9, 2008 Author Share Posted August 9, 2008 no Quote Link to comment Share on other sites More sharing options...
DarkWater Posted August 9, 2008 Share Posted August 9, 2008 Well, I'd fix that if I were you. Then you can just do simple subtraction on timestamps returned from the UNIX_TIMESTAMP() function in MySQL. Quote Link to comment Share on other sites More sharing options...
Jabop Posted August 9, 2008 Share Posted August 9, 2008 Well, I'd fix that if I were you. Then you can just do simple subtraction on timestamps returned from the UNIX_TIMESTAMP() function in MySQL. For somethign as simple you could just do xx-xx-2009 00:00:00 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.