Time converting question

[coolbeansdude51]

I am working with time in PHP and MySQL.

 

I need to store a timestamp into a mysql database when something occurs on my server.

 

I then need to pull that from the database and display it to the user in the users specific timezone. I plan on storing the users timezone in the database as well. I need to be able to convert that time to different time zones easily and simply.

 

Should I use:

 

php time()/date()

mysql datetime/timestamp

 

What is the easiest way to convert this time variable?

 

Thanks so much for your knowledge!