08.11.2010, 22:34
I have the following:
How to fix? Also How to stop a loop from running if the row is empty or not excistant.
pawn Код:
CheckMySQL();
new string[500];
format(string, 500, "INSERT INTO `houses` (`HouseIntCoordsX`, `HouseIntCoordsY`, `HouseIntCoordsZ`, `Interior`, `Vworld`) VALUES ('%f', '%f', '%f', '%d', '%d') WHERE `House-IDD` = '%d' ", HouseIntCoordsX1,HouseIntCoordsY1,HouseIntCoordsZ1,Interior1,VirtualWorld1,HouseID);
mysql_query(string);
MySQL server version for the right syntax to use near 'WHERE `House-IDD` = '0'' at line 1)