Sr. Web Developer
mediabistro.com
US-NY-New York

Justtechjobs.com Post A Job | Post A Resume

Comments for: ehresman20030911

Message # 1020920:
Date: 07/07/04 05:30
By: Olav Alexander Mjelde
Subject: RE: A better way to go..

I made my own script complete now...
I found a problem: mysql doesent have timezones!

But, if you have a timezone table (iso3166) and a users table, where you can run natural joins, you can find out if the user has 1 or more TZ for his/her country..

if > 1, show dropdown list with TZ..
else, select TZ as default..

Then you use the putenv..

but, what about the mysql??
You need to run a date command with the difference from the php and mysql timezone in your queries.. quite easy actually..

Previous Message | Next Message


Comments:
RE: Is ther something wrong with this method?Jason12/01/05 19:23
cofiguring iissujamary09/17/05 13:22
I hate timezones....Ryan02/27/05 05:36
Suneel Kanuri method beats all!Marius Ooms07/30/04 13:24
RE: A better way to go..Olav Alexander Mjelde07/07/04 05:30
A better way to go..Olav Alexander Mjelde04/09/04 15:30
RE: Well DoneOlav Alexander Mjelde03/18/04 17:58
Correction - I think GMT time storage is ok!Peter Matuchniak02/10/04 00:13
RE: Here is something i did with my timezones Vinutha02/07/04 04:33
Good ArticleRoger Rain01/11/04 06:56
Here is something i did with my timezones Suneel Kanuri11/25/03 10:53
TimeZone definition in EnvironmentNikola Savic10/07/03 05:53
It's much easier if you're on *nix...Jonathan09/22/03 16:42
Sometimes it's easier to store both...Peter Matuchniak, B.Sc (Maths)09/12/03 17:32
Well DonePaul09/12/03 10:51
 

If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.

Add A Comment:

Name:

Email:

Subject:

Message:

To reduce spam posts, messages are now manually approved

You are not [logged in]. That means your account will not get credit for this post.