[PawnoQ]

hi,

i just cant figure out why this query is not working:

pawn Код:

Current_Map_Name="Jefferson";
Current_Map_Mode="TDM";

new querymap[64];
format(querymap, sizeof(querymap), "UPDATE list SET map='%s [%s]', player='0'",Current_Map_Name,Current_Map_Mode);
mysql_query(querymap);

Before i added the [%s] part it was working just fine, now it tells me wrong mysql syntax.


thanks.

[Capua]

pawn Код:

format(querymap, sizeof(querymap), "UPDATE list SET map='%s', '%s', player='0'",Current_Map_Name,Current_Map_Mode);

[PawnoQ]

not working.
Also i would like to have the brackets in the query...

[Jonesy96]

EDIT - Nevermind

[Misiur]

Could you paste here your syntax error message?

[PawnoQ]

just this: [MySQL] Error (0): Failed to exeute 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.

[Capua]

pawn Код:

Current_Map_Name="Jefferson";
Current_Map_Mode="TDM";
new mapstring[100];
format(mapstring, sizeof(mapstring), "%s [%s]",Current_Map_Name,Current_Map_Mode);
new querymap[64];
format(querymap, sizeof(querymap), "UPDATE `list` SET map = '%s', player = '0'", mapstring);
mysql_query(querymap);

Now?

[Runn3R]

pawn Код:

format(querymap, sizeof(querymap), "UPDATE `list` SET `map`='%s', player='0'",Current_Map_Name);

Try now.

EDIT: TOO LATE.

[AnthonyTimmers]

put print(querymap) in, and please tell me what is written in the console so I can see what's wrong.