Pogledajte određenu poruku
Staro 20. 01. 2011.   #12
uros
novi član
 
Avatar uros
 
Datum učlanjenja: 06.11.2010
Poruke: 9
Hvala: 0
2 "Hvala" u 2 poruka
uros is on a distinguished road
Default

preciscena verzija... za slucaj da jos neko ne zeli Rospi Cupriju, Tosin Bunar etc...

gradove sam pokupio sa belih strana...

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');
uros je offline   Odgovorite uz citat