I need to know what should I do to show event time (stored in mysql) according viewer's local time.
I have stored time in two format (one simple 12:30; and another in timestamp format). The timings are of future and stored as GMT.
Now, I would like to show time of event according to the viewer's location. Suppose Visitor is from India than Time should be in IST (GMT + 05:30 Hours). How its possible ?
I have no idea how to fetch data from mysql and convert it to show offset time.
I might be wrong, about what I am telling. It should be like this - http://www.cricinfo.com/england-v-australia-2010/content/series/426337.html?template=fixtures
What I see as of now is this http://img293.imageshack.us/img293/4341/75715530.png
What I see is like below. When you see the url, it will time according to your ip (or zone no idea)
I think I might also need to use http://www.maxmind.com/app/free