setting timezone of comments left by users by selecting country n city frm dropd

[kee2ka4]

I have a website that displays comment and the date/time of the comments left by users. It currently saves the date and time of the comment into the database using the mysql now() function that uses the server's timezone and hence display the server timezone when showing when the comments was left on the site.

 

I want to include a drop down field that allows users to select country and city and based on the user's selection it displays the appropriate timezone. Can anyone plz provide me with some guidence as to how I can achieve that.

 

Thanks,

Ket

[revraz]

Create a list with all the time zones and their major cities, and then just read the table and display it as a dropdown.  Store their choice (I would just store their offset) along with their user data.