What wrong with this load a save house system
#9

Quote:
Originally Posted by r0b
Посмотреть сообщение
If you want to save a new one, you need to insert:
INSERT INTO table (column,column,column) VALUES ('value','value','value')
I have tried that all i get is errors in the mysq_log
This happens right when savehouses gets used
Код:
[08/09/10 06:20:43] Error (0): Could not execute query. 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 '1124710895','1105035264','0','0','0','0','0','100','0','0','0','0','0','0','0','' at line 1.

[08/09/10 06:20:43] Error (0): Could not execute query. 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 '1124710895','1105035264','0','0','0','0','0','100','0','0','0','0','0','0','0','' at line 1.
Here is the Insert into

pawn Код:
format(sql, sizeof(sql), "INSERT INTO property (Howner,Enterx,Enterz,Enterz,Exitx,Exity,Exitz,Hint,Hworld,Hprice,Rentprice,Hrentable,Hlocked,Hdrugs,Hmats,Hgun1,Hammo1,Hgun2,Hammo2,Hgun3,Hammo3,Hmoney,Howned,Hlevel) VALUES ('%s','$f','$f','$f','$f','$f','$f','%d,'%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')",
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)