ebay style auction clock

[thegreatdanton]

Hi all,

Sorry if this is in the wrong forum but i'm trying to build an auction style countdown clock like the one that is on e-bay. This should relate to a MySQL database. So once the user submits a form and the data goes into the database then the auction time should begin.

I'm just wondering if anyone knows how it is done or could point me to a resource that could get me started.

I'd appreciate any suggestions anyone has.

Thanks for your help

[ixalmida]

All you need to do is store the "end_time" in your database. You can get "now" from the MySQL NOW() expression, or the PHP mktime() expression.

Once you calculate "end_time - now", you have your time remaining! You can then display it as a static "h:m" value, or you can plug the seconds left into a Javascript countdown clock that can run down to 0 without the user refreshing the page.