SA-MP Forums Archive
MySQL Syntax - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL Syntax (/showthread.php?tid=117613)


MySQL Syntax - Josh! - 01.01.2010

pawn Код:
new Float:cx, Float:cy, Float:cz;
    GetPlayerPos(playerid, cx, cy, cz);
    format(sql, 256,"INSERT INTO bizz (id,owned,owner,message,extortion,ent_x,ent_y,ent_z,exit_x,exit_y,exit_z,level,price,ent_cost,till,locked,interior,products,maxprod,priceprod,world) VALUES (%d,%d,'%s','%s','%s',%f,%f,%f,%f,%f,%f,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d)",
    bizzid,0,"No-one","None","No-one",cx,cy,cz,0.0,0.0,0.0,0,100000,0,0,0,0,0,0,0,bizzid);
    samp_mysql_query(sql);
Error in mysql_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 '' at line 1

Anyone know why?