Quote:
Originally Posted by KyleSmith
I have the following:
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)
How to fix? Also How to stop a loop from running if the row is empty or not excistant.
|
What are you trying to achieve?