i enters date and time into my database table.. after that i select this time and date in a query.
all that i need is to countdown the timer from time now to the date that i select from databse

example:
i got from database the time in which the data is inserted:

$result = 2009-12-02 05:34:58;

now i want to count down the time from now

2009-12-02 06:34:58;

to $result


so it will count 01:00:00 too 00:00:00


Note : i wnt the countdown timer to be shown to the user i dont want to tell him that there is one hour left, i want to show the time that counts from now to result.

can anyone help me in doing this module?

Can't be done with PHP. PHP runs on the server and cannot send data back to the client with a request being made.

A java applet is the only way of maintaining a running server countdown for one hour without crashing browsers.

You can do this with crontab together with some additional checks.

One possible way of solution is to do check the elapsed time, not to count off each second