*** Not a descriptive title - ******.
#1

when server saving cars into mysql apear some problems, the car system include and name pos of car spawn, but for some specifically posion names have the ' what to do?
Код:
[18:31:41] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Bullet', Owner = 'None', Pos = 'King's',X = '-2223.080078', Y = '293.543792', Z = '34.742198' WHERE CID = 154
[18:31:41] 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 's',X = '-2223.080078', Y = '293.543792', Z = '34.742198' WHERE CID = 154' at line 1
[18:31:41] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Jester', Owner = 'None', Pos = 'King's',X = '-2176.084716', Y = '306.322601', Z = '34.773498' WHERE CID = 156
[18:31:41] 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 's',X = '-2176.084716', Y = '306.322601', Z = '34.773498' WHERE CID = 156' at line 1
[18:31:45] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Quad', Owner = 'None', Pos = 'King's',X = '-2188.941406', Y = '292.803009', Z = '34.822200' WHERE CID = 171
[18:31:45] 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 's',X = '-2188.941406', Y = '292.803009', Z = '34.822200' WHERE CID = 171' at line 1
[18:31:45] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'BF Injection', Owner = 'None', Pos = 'King's',X = '-2205.948242', Y = '292.931793', Z = '34.896598' WHERE CID = 173
[18:31:45] 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 's',X = '-2205.948242', Y = '292.931793', Z = '34.896598' WHERE CID = 173' at line 1
[18:31:49] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Feltzer', Owner = 'None', Pos = 'King's',X = '-2180.025634', Y = '293.104003', Z = '34.826301' WHERE CID = 188
[18:31:49] 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 's',X = '-2180.025634', Y = '293.104003', Z = '34.826301' WHERE CID = 188' at line 1
[18:31:56] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Buffalo', Owner = 'None', Pos = 'King's',X = '-2183.868896', Y = '306.067901', Z = '34.692401' WHERE CID = 215
[18:31:56] 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 's',X = '-2183.868896', Y = '306.067901', Z = '34.692401' WHERE CID = 215' at line 1
[18:32:01] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Slamvan', Owner = 'None', Pos = 'King's',X = '-2167.921630', Y = '305.908203', Z = '34.690399' WHERE CID = 231
[18:32:01] 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 's',X = '-2167.921630', Y = '305.908203', Z = '34.690399' WHERE CID = 231' at line 1
[18:32:01] Incoming connection: 192.168.0.100:55035
[18:32:02] [join] Tester has joined the server (0:192.168.0.100)
[18:32:03] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Infernus', Owner = 'None', Pos = 'The Clown's Pocket',X = '2315.497314', Y = '1793.088378', Z = '10.547400' WHERE CID = 234
[18:32:03] 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 's Pocket',X = '2315.497314', Y = '1793.088378', Z = '10.547400' WHERE CID = 234' at line 1
[18:32:13] Something is wrong dunno what, query: UPDATE vehicles SET Description = 'Admiral', Owner = 'None', Pos = 'King's',X = '-2214.157714', Y = '293.080993', Z = '34.992198' WHERE CID = 273
[18:32:13] 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 's',X = '-2214.157714', Y = '293.080993', Z = '34.992198' WHERE CID = 273' at line 1
Reply
#2

mysql_real_escape_string().
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)