PHP Timezone MySQL List

SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = 'SYSTEM';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `tz`;
CREATE TABLE `tz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `tz` (`id`, `name`) VALUES
(1, 'Africa/Abidjan'),
(2, 'Africa/Accra'),
(3, 'Africa/Addis_Ababa'),
(4, 'Africa/Algiers'),
(5, 'Africa/Asmara'),
(6, 'Africa/Asmera'),
(7, 'Africa/Bamako'),
(8, 'Africa/Bangui'),
(9, 'Africa/Banjul'),
(10,    'Africa/Bissau'),
(11,    'Africa/Blantyre'),
(12,    'Africa/Brazzaville'),
(13,    'Africa/Bujumbura'),
(14,    'Africa/Cairo'),
(15,    'Africa/Casablanca'),
(16,    'Africa/Ceuta'),
(17,    'Africa/Conakry'),
(18,    'Africa/Dakar'),
(19,    'Africa/Dar_es_Salaam'),
(20,    'Africa/Djibouti'),
(21,    'Africa/Douala'),
(22,    'Africa/El_Aaiun'),
(23,    'Africa/Freetown'),
(24,    'Africa/Gaborone'),
(25,    'Africa/Harare'),
(26,    'Africa/Johannesburg'),
(27,    'Africa/Juba'),
(28,    'Africa/Kampala'),
(29,    'Africa/Khartoum'),
(30,    'Africa/Kigali'),
(31,    'Africa/Kinshasa'),
(32,    'Africa/Lagos'),
(33,    'Africa/Libreville'),
(34,    'Africa/Lome'),
(35,    'Africa/Luanda'),
(36,    'Africa/Lubumbashi'),
(37,    'Africa/Lusaka'),
(38,    'Africa/Malabo'),
(39,    'Africa/Maputo'),
(40,    'Africa/Maseru'),
(41,    'Africa/Mbabane'),
(42,    'Africa/Mogadishu'),
(43,    'Africa/Monrovia'),
(44,    'Africa/Nairobi'),
(45,    'Africa/Ndjamena'),
(46,    'Africa/Niamey'),
(47,    'Africa/Nouakchott'),
(48,    'Africa/Ouagadougou'),
(49,    'Africa/Porto-Novo'),
(50,    'Africa/Sao_Tome'),
(51,    'Africa/Timbuktu'),
(52,    'Africa/Tripoli'),
(53,    'Africa/Tunis'),
(54,    'Africa/Windhoek'),
(55,    'AKST9AKDT'),
(56,    'America/Adak'),
(57,    'America/Anchorage'),
(58,    'America/Anguilla'),
(59,    'America/Antigua'),
(60,    'America/Araguaina'),
(61,    'America/Argentina/Buenos_Aires'),
(62,    'America/Argentina/Catamarca'),
(63,    'America/Argentina/ComodRivadavia'),
(64,    'America/Argentina/Cordoba'),
(65,    'America/Argentina/Jujuy'),
(66,    'America/Argentina/La_Rioja'),
(67,    'America/Argentina/Mendoza'),
(68,    'America/Argentina/Rio_Gallegos'),
(69,    'America/Argentina/Salta'),
(70,    'America/Argentina/San_Juan'),
(71,    'America/Argentina/San_Luis'),
(72,    'America/Argentina/Tucuman'),
(73,    'America/Argentina/Ushuaia'),
(74,    'America/Aruba'),
(75,    'America/Asuncion'),
(76,    'America/Atikokan'),
(77,    'America/Atka'),
(78,    'America/Bahia'),
(79,    'America/Bahia_Banderas'),
(80,    'America/Barbados'),
(81,    'America/Belem'),
(82,    'America/Belize'),
(83,    'America/Blanc-Sablon'),
(84,    'America/Boa_Vista'),
(85,    'America/Bogota'),
(86,    'America/Boise'),
(87,    'America/Buenos_Aires'),
(88,    'America/Cambridge_Bay'),
(89,    'America/Campo_Grande'),
(90,    'America/Cancun'),
(91,    'America/Caracas'),
(92,    'America/Catamarca'),
(93,    'America/Cayenne'),
(94,    'America/Cayman'),
(95,    'America/Chicago'),
(96,    'America/Chihuahua'),
(97,    'America/Coral_Harbour'),
(98,    'America/Cordoba'),
(99,    'America/Costa_Rica'),
(100,   'America/Creston'),
(101,   'America/Cuiaba'),
(102,   'America/Curacao'),
(103,   'America/Danmarkshavn'),
(104,   'America/Dawson'),
(105,   'America/Dawson_Creek'),
(106,   'America/Denver'),
(107,   'America/Detroit'),
(108,   'America/Dominica'),
(109,   'America/Edmonton'),
(110,   'America/Eirunepe'),
(111,   'America/El_Salvador'),
(112,   'America/Ensenada'),
(113,   'America/Fort_Wayne'),
(114,   'America/Fortaleza'),
(115,   'America/Glace_Bay'),
(116,   'America/Godthab'),
(117,   'America/Goose_Bay'),
(118,   'America/Grand_Turk'),
(119,   'America/Grenada'),
(120,   'America/Guadeloupe'),
(121,   'America/Guatemala'),
(122,   'America/Guayaquil'),
(123,   'America/Guyana'),
(124,   'America/Halifax'),
(125,   'America/Havana'),
(126,   'America/Hermosillo'),
(127,   'America/Indiana/Indianapolis'),
(128,   'America/Indiana/Knox'),
(129,   'America/Indiana/Marengo'),
(130,   'America/Indiana/Petersburg'),
(131,   'America/Indiana/Tell_City'),
(132,   'America/Indiana/Vevay'),
(133,   'America/Indiana/Vincennes'),
(134,   'America/Indiana/Winamac'),
(135,   'America/Indianapolis'),
(136,   'America/Inuvik'),
(137,   'America/Iqaluit'),
(138,   'America/Jamaica'),
(139,   'America/Jujuy'),
(140,   'America/Juneau'),
(141,   'America/Kentucky/Louisville'),
(142,   'America/Kentucky/Monticello'),
(143,   'America/Knox_IN'),
(144,   'America/Kralendijk'),
(145,   'America/La_Paz'),
(146,   'America/Lima'),
(147,   'America/Los_Angeles'),
(148,   'America/Louisville'),
(149,   'America/Lower_Princes'),
(150,   'America/Maceio'),
(151,   'America/Managua'),
(152,   'America/Manaus'),
(153,   'America/Marigot'),
(154,   'America/Martinique'),
(155,   'America/Matamoros'),
(156,   'America/Mazatlan'),
(157,   'America/Mendoza'),
(158,   'America/Menominee'),
(159,   'America/Merida'),
(160,   'America/Metlakatla'),
(161,   'America/Mexico_City'),
(162,   'America/Miquelon'),
(163,   'America/Moncton'),
(164,   'America/Monterrey'),
(165,   'America/Montevideo'),
(166,   'America/Montreal'),
(167,   'America/Montserrat'),
(168,   'America/Nassau'),
(169,   'America/New_York'),
(170,   'America/Nipigon'),
(171,   'America/Nome'),
(172,   'America/Noronha'),
(173,   'America/North_Dakota/Beulah'),
(174,   'America/North_Dakota/Center'),
(175,   'America/North_Dakota/New_Salem'),
(176,   'America/Ojinaga'),
(177,   'America/Panama'),
(178,   'America/Pangnirtung'),
(179,   'America/Paramaribo'),
(180,   'America/Phoenix'),
(181,   'America/Port_of_Spain'),
(182,   'America/Port-au-Prince'),
(183,   'America/Porto_Acre'),
(184,   'America/Porto_Velho'),
(185,   'America/Puerto_Rico'),
(186,   'America/Rainy_River'),
(187,   'America/Rankin_Inlet'),
(188,   'America/Recife'),
(189,   'America/Regina'),
(190,   'America/Resolute'),
(191,   'America/Rio_Branco'),
(192,   'America/Rosario'),
(193,   'America/Santa_Isabel'),
(194,   'America/Santarem'),
(195,   'America/Santiago'),
(196,   'America/Santo_Domingo'),
(197,   'America/Sao_Paulo'),
(198,   'America/Scoresbysund'),
(199,   'America/Shiprock'),
(200,   'America/Sitka'),
(201,   'America/St_Barthelemy'),
(202,   'America/St_Johns'),
(203,   'America/St_Kitts'),
(204,   'America/St_Lucia'),
(205,   'America/St_Thomas'),
(206,   'America/St_Vincent'),
(207,   'America/Swift_Current'),
(208,   'America/Tegucigalpa'),
(209,   'America/Thule'),
(210,   'America/Thunder_Bay'),
(211,   'America/Tijuana'),
(212,   'America/Toronto'),
(213,   'America/Tortola'),
(214,   'America/Vancouver'),
(215,   'America/Virgin'),
(216,   'America/Whitehorse'),
(217,   'America/Winnipeg'),
(218,   'America/Yakutat'),
(219,   'America/Yellowknife'),
(220,   'Antarctica/Casey'),
(221,   'Antarctica/Davis'),
(222,   'Antarctica/DumontDUrville'),
(223,   'Antarctica/Macquarie'),
(224,   'Antarctica/Mawson'),
(225,   'Antarctica/McMurdo'),
(226,   'Antarctica/Palmer'),
(227,   'Antarctica/Rothera'),
(228,   'Antarctica/South_Pole'),
(229,   'Antarctica/Syowa'),
(230,   'Antarctica/Vostok'),
(231,   'Arctic/Longyearbyen'),
(232,   'Asia/Aden'),
(233,   'Asia/Almaty'),
(234,   'Asia/Amman'),
(235,   'Asia/Anadyr'),
(236,   'Asia/Aqtau'),
(237,   'Asia/Aqtobe'),
(238,   'Asia/Ashgabat'),
(239,   'Asia/Ashkhabad'),
(240,   'Asia/Baghdad'),
(241,   'Asia/Bahrain'),
(242,   'Asia/Baku'),
(243,   'Asia/Bangkok'),
(244,   'Asia/Beirut'),
(245,   'Asia/Bishkek'),
(246,   'Asia/Brunei'),
(247,   'Asia/Calcutta'),
(248,   'Asia/Choibalsan'),
(249,   'Asia/Chongqing'),
(250,   'Asia/Chungking'),
(251,   'Asia/Colombo'),
(252,   'Asia/Dacca'),
(253,   'Asia/Damascus'),
(254,   'Asia/Dhaka'),
(255,   'Asia/Dili'),
(256,   'Asia/Dubai'),
(257,   'Asia/Dushanbe'),
(258,   'Asia/Gaza'),
(259,   'Asia/Harbin'),
(260,   'Asia/Hebron'),
(261,   'Asia/Ho_Chi_Minh'),
(262,   'Asia/Hong_Kong'),
(263,   'Asia/Hovd'),
(264,   'Asia/Irkutsk'),
(265,   'Asia/Istanbul'),
(266,   'Asia/Jakarta'),
(267,   'Asia/Jayapura'),
(268,   'Asia/Jerusalem'),
(269,   'Asia/Kabul'),
(270,   'Asia/Kamchatka'),
(271,   'Asia/Karachi'),
(272,   'Asia/Kashgar'),
(273,   'Asia/Kathmandu'),
(274,   'Asia/Katmandu'),
(275,   'Asia/Kolkata'),
(276,   'Asia/Krasnoyarsk'),
(277,   'Asia/Kuala_Lumpur'),
(278,   'Asia/Kuching'),
(279,   'Asia/Kuwait'),
(280,   'Asia/Macao'),
(281,   'Asia/Macau'),
(282,   'Asia/Magadan'),
(283,   'Asia/Makassar'),
(284,   'Asia/Manila'),
(285,   'Asia/Muscat'),
(286,   'Asia/Nicosia'),
(287,   'Asia/Novokuznetsk'),
(288,   'Asia/Novosibirsk'),
(289,   'Asia/Omsk'),
(290,   'Asia/Oral'),
(291,   'Asia/Phnom_Penh'),
(292,   'Asia/Pontianak'),
(293,   'Asia/Pyongyang'),
(294,   'Asia/Qatar'),
(295,   'Asia/Qyzylorda'),
(296,   'Asia/Rangoon'),
(297,   'Asia/Riyadh'),
(298,   'Asia/Saigon'),
(299,   'Asia/Sakhalin'),
(300,   'Asia/Samarkand'),
(301,   'Asia/Seoul'),
(302,   'Asia/Shanghai'),
(303,   'Asia/Singapore'),
(304,   'Asia/Taipei'),
(305,   'Asia/Tashkent'),
(306,   'Asia/Tbilisi'),
(307,   'Asia/Tehran'),
(308,   'Asia/Tel_Aviv'),
(309,   'Asia/Thimbu'),
(310,   'Asia/Thimphu'),
(311,   'Asia/Tokyo'),
(312,   'Asia/Ujung_Pandang'),
(313,   'Asia/Ulaanbaatar'),
(314,   'Asia/Ulan_Bator'),
(315,   'Asia/Urumqi'),
(316,   'Asia/Vientiane'),
(317,   'Asia/Vladivostok'),
(318,   'Asia/Yakutsk'),
(319,   'Asia/Yekaterinburg'),
(320,   'Asia/Yerevan'),
(321,   'Atlantic/Azores'),
(322,   'Atlantic/Bermuda'),
(323,   'Atlantic/Canary'),
(324,   'Atlantic/Cape_Verde'),
(325,   'Atlantic/Faeroe'),
(326,   'Atlantic/Faroe'),
(327,   'Atlantic/Jan_Mayen'),
(328,   'Atlantic/Madeira'),
(329,   'Atlantic/Reykjavik'),
(330,   'Atlantic/South_Georgia'),
(331,   'Atlantic/St_Helena'),
(332,   'Atlantic/Stanley'),
(333,   'Australia/ACT'),
(334,   'Australia/Adelaide'),
(335,   'Australia/Brisbane'),
(336,   'Australia/Broken_Hill'),
(337,   'Australia/Canberra'),
(338,   'Australia/Currie'),
(339,   'Australia/Darwin'),
(340,   'Australia/Eucla'),
(341,   'Australia/Hobart'),
(342,   'Australia/LHI'),
(343,   'Australia/Lindeman'),
(344,   'Australia/Lord_Howe'),
(345,   'Australia/Melbourne'),
(346,   'Australia/North'),
(347,   'Australia/NSW'),
(348,   'Australia/Perth'),
(349,   'Australia/Queensland'),
(350,   'Australia/South'),
(351,   'Australia/Sydney'),
(352,   'Australia/Tasmania'),
(353,   'Australia/Victoria'),
(354,   'Australia/West'),
(355,   'Australia/Yancowinna'),
(356,   'Brazil/Acre'),
(357,   'Brazil/DeNoronha'),
(358,   'Brazil/East'),
(359,   'Brazil/West'),
(360,   'Canada/Atlantic'),
(361,   'Canada/Central'),
(362,   'Canada/Eastern'),
(363,   'Canada/East-Saskatchewan'),
(364,   'Canada/Mountain'),
(365,   'Canada/Newfoundland'),
(366,   'Canada/Pacific'),
(367,   'Canada/Saskatchewan'),
(368,   'Canada/Yukon'),
(369,   'Europe/Amsterdam'),
(370,   'Europe/Andorra'),
(371,   'Europe/Athens'),
(372,   'Europe/Belfast'),
(373,   'Europe/Belgrade'),
(374,   'Europe/Berlin'),
(375,   'Europe/Bratislava'),
(376,   'Europe/Brussels'),
(377,   'Europe/Bucharest'),
(378,   'Europe/Budapest'),
(379,   'Europe/Chisinau'),
(380,   'Europe/Copenhagen'),
(381,   'Europe/Dublin'),
(382,   'Europe/Gibraltar'),
(383,   'Europe/Guernsey'),
(384,   'Europe/Helsinki'),
(385,   'Europe/Isle_of_Man'),
(386,   'Europe/Istanbul'),
(387,   'Europe/Jersey'),
(388,   'Europe/Kaliningrad'),
(389,   'Europe/Kiev'),
(390,   'Europe/Lisbon'),
(391,   'Europe/Ljubljana'),
(392,   'Europe/London'),
(393,   'Europe/Luxembourg'),
(394,   'Europe/Madrid'),
(395,   'Europe/Malta'),
(396,   'Europe/Mariehamn'),
(397,   'Europe/Minsk'),
(398,   'Europe/Monaco'),
(399,   'Europe/Moscow'),
(400,   'Europe/Nicosia'),
(401,   'Europe/Oslo'),
(402,   'Europe/Paris'),
(403,   'Europe/Podgorica'),
(404,   'Europe/Prague'),
(405,   'Europe/Riga'),
(406,   'Europe/Rome'),
(407,   'Europe/Samara'),
(408,   'Europe/San_Marino'),
(409,   'Europe/Sarajevo'),
(410,   'Europe/Simferopol'),
(411,   'Europe/Skopje'),
(412,   'Europe/Sofia'),
(413,   'Europe/Stockholm'),
(414,   'Europe/Tallinn'),
(415,   'Europe/Tirane'),
(416,   'Europe/Tiraspol'),
(417,   'Europe/Uzhgorod'),
(418,   'Europe/Vaduz'),
(419,   'Europe/Vatican'),
(420,   'Europe/Vienna'),
(421,   'Europe/Vilnius'),
(422,   'Europe/Volgograd'),
(423,   'Europe/Warsaw'),
(424,   'Europe/Zagreb'),
(425,   'Europe/Zaporozhye'),
(426,   'Europe/Zurich'),
(427,   'Iceland'),
(428,   'Indian/Antananarivo'),
(429,   'Indian/Chagos'),
(430,   'Indian/Christmas'),
(431,   'Indian/Cocos'),
(432,   'Indian/Comoro'),
(433,   'Indian/Kerguelen'),
(434,   'Indian/Mahe'),
(435,   'Indian/Maldives'),
(436,   'Indian/Mauritius'),
(437,   'Indian/Mayotte'),
(438,   'Indian/Reunion'),
(439,   'Iran'),
(440,   'Israel'),
(441,   'Jamaica'),
(442,   'Japan'),
(443,   'Kwajalein'),
(444,   'Libya'),
(445,   'Mexico/BajaNorte'),
(446,   'Mexico/BajaSur'),
(447,   'Mexico/General'),
(448,   'MST7MDT'),
(449,   'Navajo'),
(450,   'Pacific/Apia'),
(451,   'Pacific/Auckland'),
(452,   'Pacific/Chatham'),
(453,   'Pacific/Chuuk'),
(454,   'Pacific/Easter'),
(455,   'Pacific/Efate'),
(456,   'Pacific/Enderbury'),
(457,   'Pacific/Fakaofo'),
(458,   'Pacific/Fiji'),
(459,   'Pacific/Funafuti'),
(460,   'Pacific/Galapagos'),
(461,   'Pacific/Gambier'),
(462,   'Pacific/Guadalcanal'),
(463,   'Pacific/Guam'),
(464,   'Pacific/Honolulu'),
(465,   'Pacific/Johnston'),
(466,   'Pacific/Kiritimati'),
(467,   'Pacific/Kosrae'),
(468,   'Pacific/Kwajalein'),
(469,   'Pacific/Majuro'),
(470,   'Pacific/Marquesas'),
(471,   'Pacific/Midway'),
(472,   'Pacific/Nauru'),
(473,   'Pacific/Niue'),
(474,   'Pacific/Norfolk'),
(475,   'Pacific/Noumea'),
(476,   'Pacific/Pago_Pago'),
(477,   'Pacific/Palau'),
(478,   'Pacific/Pitcairn'),
(479,   'Pacific/Pohnpei'),
(480,   'Pacific/Ponape'),
(481,   'Pacific/Port_Moresby'),
(482,   'Pacific/Rarotonga'),
(483,   'Pacific/Saipan'),
(484,   'Pacific/Samoa'),
(485,   'Pacific/Tahiti'),
(486,   'Pacific/Tarawa'),
(487,   'Pacific/Tongatapu'),
(488,   'Pacific/Truk'),
(489,   'Pacific/Wake'),
(490,   'Pacific/Wallis'),
(491,   'Pacific/Yap'),
(492,   'Poland'),
(493,   'Portugal'),
(494,   'Singapore'),
(495,   'Turkey'),
(496,   'Universal'),
(497,   'US/Alaska'),
(498,   'US/Aleutian'),
(499,   'US/Arizona'),
(500,   'US/Central'),
(501,   'US/Eastern'),
(502,   'US/East-Indiana'),
(503,   'US/Hawaii'),
(504,   'US/Indiana-Starke'),
(505,   'US/Michigan'),
(506,   'US/Mountain'),
(507,   'US/Pacific'),
(508,   'US/Pacific-New'),
(509,   'US/Samoa'),
(510,   'UTC'),
(511,   'EST'),
(512,   'GMT');

-- 2013-04-18 19:46:34