Countdown to auction closing date and time

[mmponline]

I have a table named Auctions with the following fields:
Name, ClosingDate, TimeLeft

I need a code to insert in the TimeLeft field to display the time left from now to the ClosingDate.

IOW if the time/date is now 12:00 on 6 May 2008 and the CclosingDate and time is 8 May 2008 13:00, te displayed time in TimeLeft should be 2 Days 1 hour.

How can I achieve this?

Further: I'd like this time /date to "refresh" say every 1 min.

Thanks for any help.

[leatherback]

Why don't you just prepare the time to closing whenever a user reloads the page? Why store something that dynamic in the database?

J.

[mmponline]

I'll settle for the reload option. Still I need the code, as I don't know how. Can you asist?

[malbera]

This can be a good start 🙂

select timediff(NOW(), ClosingDate) from Auctions;

the result will be like this:

mysql> select timediff(NOW(), ClosingDate) as remainig from Auctions;
+---------+
| remainig |
+---------+
| 09:42:55 |
| 00:03:55 |
| 24:03:55 |
+---------+

[mmponline]

I need to put a custom code in the Time left field so that each record will show the time left. Otherwise some event...