Mysql Syntax
#1

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.
Reply


Messages In This Thread
Mysql Syntax - by Kyle - 08.11.2010, 22:34
Re: Mysql Syntax - by DarrenReeder - 08.11.2010, 22:36
Re: Mysql Syntax - by Kyle - 09.11.2010, 09:21
Re: Mysql Syntax - by Rachael - 09.11.2010, 09:23
Re: Mysql Syntax - by iJumbo - 09.11.2010, 12:47
Re: Mysql Syntax - by Cameltoe - 09.11.2010, 12:54
Re: Mysql Syntax - by Bumbis - 09.11.2010, 13:14
Re: Mysql Syntax - by LarzI - 09.11.2010, 13:20
Re: Mysql Syntax - by Cameltoe - 09.11.2010, 13:27

Forum Jump:


Users browsing this thread: 1 Guest(s)