SA-MP Forums Archive
MySQL Help! Fast please. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Help! Fast please. (/showthread.php?tid=603796)


MySQL Help! Fast please. - Belengher - 27.03.2016

How is it fair use?

Код HTML:
					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE `id` = '%d'", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);
Код HTML:
					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE id= %d", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);
Код HTML:
					format(var, sizeof(var), "UPDATE `players` SET `Registered` = '%d' WHERE `id`= %d", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]);
					mysql_query(var);
Please help me!
Which of the above are good?

Sorry for myy bad english

Re: MySQL Help! Fast please. - SickAttack - 27.03.2016

1st one.

Re: MySQL Help! Fast please. - Belengher - 28.03.2016

The first version is correct?

Re: MySQL Help! Fast please. - AmigaBlizzard - 28.03.2016

PHP код:
format(var, sizeof(var), "UPDATE players SET Registered = '%d' WHERE id = '%d'", PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSQLID]); 
This also works fine.
Just put your data between ' and you'll do fine.