lava172
Умник
PHP:
--
-- Структура таблицы `Houses`
--
CREATE TABLE IF NOT EXISTS `Houses` (
`house` int(11) NOT NULL AUTO_INCREMENT,
`hEntrancex` float NOT NULL,
`hEntrancey` float NOT NULL,
`hEntrancez` float NOT NULL,
`hExitx` float NOT NULL,
`hExity` float NOT NULL,
`hExitz` float NOT NULL,
`hOwner` varchar(24) NOT NULL,
`hValue` int(11) DEFAULT NULL,
`hInt` int(11) DEFAULT NULL,
`hLock` int(11) DEFAULT NULL,
`hOwned` int(11) NOT NULL,
`hRentabil` int(11) DEFAULT NULL,
`hDate` int(11) DEFAULT NULL,
`hVirtual` int(11) DEFAULT NULL,
`Hname` varchar(60) NOT NULL,
`Money` int(11) DEFAULT NULL,
PRIMARY KEY (`house`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=747;
PHP:
--
-- Дамп данных таблицы `Houses`
--
INSERT INTO `Houses` (`house`, `hEntrancex`, `hEntrancey`, `hEntrancez`, `hExitx`, `hExity`, `hExitz`, `hOwner`, `hValue`, `hInt`, `hLock`,`hOwned`,`hRentabil`,`hDate`,`hVirtual`,`Hname`,`Money`) VALUES (
1,-329.561492,1537.042114,76.611701,446.324707,509.966186,1001.419494,The State,50000,12,1,0,0,189,101,/hname,0),(
2,2449.405273,713.846374,11.468297,22.861000,1404.916503,1084.429687,The State,870000,5,1,0,0,189,1,/hname,0),(
3,2037.242797,2661.776611,10.820300,260.742095,1238.226074,1084.257812,The State,930000,9,1,0,0,189,1,/hname,0),(
и т.д...);
PHP:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'State,50000,12,1,0,0,189,101,/hname,0),( 2,2449.405273,713.846374,11.468297,22.' at line 6
