MySQL query does not work. Other thing:Array must be indexed
#5

pawn Код:
[17:45:27] CMySQLHandler::Query(INSERT INTO houses (VirtualWorld,PosX,PosY,PosZ,Price,HouseLabel) VALUES (0,-278.615264,1003.067810,20.939867,320,'Namas Parduo) - An error has occured. (Error ID: 1064, 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 ''Namas Parduo' at line 1)
Still the same error,although the line I changed:
pawn Код:
format(query,sizeof(query),"INSERT INTO houses (VirtualWorld,PosX,PosY,PosZ,Price,HouseLabel) VALUES (%d,%f,%f,%f,%d,'%s')",GetPlayerVirtualWorld(playerid),x,y,z,HousePrice,labelstring);

About the second thing, PlayerDrugs is an enum. "Preke" doesn't exist there.
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)