preciscena verzija... za slucaj da jos neko ne zeli Rospi Cupriju, Tosin Bunar etc...
Kôd:
CREATE TABLE `gradovi` (
`id` int(11) not null auto_increment,
`grad` varchar(100) not null,
`lat` varchar(10) not null,
`lon` varchar(10) not null,
PRIMARY KEY (`id`),
KEY `grad` (`grad`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34;
INSERT INTO `gradovi` (`id`, `grad`, `lat`, `lon`) VALUES
('1', 'Beograd', '44.818611', '20.468056'),
('2', 'Bor', '44.078333', '22.095278'),
('3', 'Cacak', '43.891389', '20.349722'),
('4', 'Gnjilane', '42.468889', '21.463333'),
('5', 'Jagodina', '43.981389', '21.262222'),
('6', 'Kikinda', '45.641111', '20.414167'),
('7', 'Kosovska Mitrovica', '42.883333', '20.866667'),
('8', 'Kragujevac', '44.016667', '20.916667'),
('9', 'Kraljevo', '43.725833', '20.689444'),
('10', 'Krusevac', '43.58', '21.333889'),
('11', 'Leskovac', '42.998056', '21.946111'),
('12', 'Nis', '43.324722', '21.903333'),
('13', 'Novi Pazar', '43.136667', '20.512222'),
('14', 'Novi Sad', '45.251667', '19.836944'),
('15', 'Pancevo', '44.870833', '20.640278'),
('16', 'Pec', '42.66', '20.292222'),
('17', 'Pirot', '43.153056', '22.586111'),
('18', 'Pozarevac', '44.615278', '21.1825'),
('19', 'Prijepolje', '43.371944', '19.640556'),
('20', 'Pristina', '42.666667', '21.166667'),
('21', 'Prizren', '42.213889', '20.739722'),
('22', 'Prokuplje', '43.234167', '21.588056'),
('23', 'Sabac', '44.746667', '19.69'),
('24', 'Smederevo', '44.662778', '20.93'),
('25', 'Sombor', '45.774167', '19.112222'),
('26', 'Sremska Mitrovica', '44.976389', '19.612222'),
('27', 'Subotica', '46.1', '19.666667'),
('28', 'Urosevac', '42.370556', '21.155278'),
('29', 'Uzice', '43.855833', '19.841111'),
('30', 'Valjevo', '44.270833', '19.884167'),
('31', 'Vranje', '42.551389', '21.900278'),
('32', 'Zajecar', '43.904167', '22.284722'),
('33', 'Zrenjanin', '45.383611', '20.381944');