2. PHPRunner General questions
  3. Displaying Time Left
This topic is locked

Displaying Time Left

 		9/4/2008 6:37:12 AM
PHPRunner General questions
F
 fawad112 author

Hi,
I need some help regarding displaying some time left on the list page. Each row has a deadline field in it. I want to show TIMELEFT on the screen as well with each row. ........Deadline - Current Time ...... how to make this work :S
J
 		Jane 9/4/2008

Hi,
edit SQL query on the Edit SQL query tab for this purpose.

Actual SQL is dependent on your database and field types.
F
 		fawad112 author 9/8/2008

hi thanks for your reply. How can i convert seconds to DD:HH:MM:SS format. I have got time left in seconds and need to convert it.
J
 		Jane 9/9/2008

If you use MySQL use TIME_TO_SEC() function:

http://dev.mysql.com/doc/refman/5.0/en/dat...ion_time-to-sec