Sve je u redu ili nikako da mi usje
$tmp_res = mysql_query($sql);
Ovoako izgleda sql fajl
Code:
CREATE TABLE `sport` (
`sport_id` smallint(5) unsigned NOT NULL default '0',
`naziv` varchar(50) default NULL,
`export_id` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`sport_id`),
KEY `ID` (`sport_id`),
KEY `Naziv` (`naziv`)
) ENGINE=MyISAM CHARACTER SET utf8;
SET SQL_MODE = 'MYSQL323';
INSERT INTO `sport` VALUES("10", "Fudbal", "1");
INSERT INTO `sport` VALUES("20", "Košarka", "2");
INSERT INTO `sport` VALUES("30", "Tenis", "3");
INSERT INTO `sport` VALUES("40", "Formula 1", "4");
INSERT INTO `sport` VALUES("45", "Moto trki", "4");
INSERT INTO `sport` VALUES("50", "Golovi vo liga", "5");
INSERT INTO `sport` VALUES("55", "Super Tip", "11");
INSERT INTO `sport` VALUES("60", "Hokej", "6");
INSERT INTO `sport` VALUES("70", "Rakomet", "7");
INSERT INTO `sport` VALUES("80", "Američki fudbal", "8");
INSERT INTO `sport` VALUES("90", "Odbojka", "3");
INSERT INTO `sport` VALUES("100", "Vaterpolo", "7");
INSERT INTO `sport` VALUES("105", "Ski sportovi", "14");
INSERT INTO `sport` VALUES("110", "Atletika", "15");
INSERT INTO `sport` VALUES("115", "Boks", "16");
INSERT INTO `sport` VALUES("120", "Ragbi", "8");
INSERT INTO `sport` VALUES("130", "Politika", "12");
INSERT INTO `sport` VALUES("140", "Zabava", "13");
Da napomenem da preko phpmyadmina sve je Ok.