MySQL Syntax
#1

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


Forum Jump:


Users browsing this thread: 1 Guest(s)