SA-MP Forums Archive
Error with mysql INSERT - 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)
+--- Thread: Error with mysql INSERT (/showthread.php?tid=657980)


Error with mysql INSERT - Stormalle - 19.08.2018

hello, my code doesnt insert business info into database, and i get this error

[20:25:00] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Storm_alle' in 'field list'

Storm_alle is my nickname


my line:

Код HTML:
	format(query, sizeof(query), "INSERT INTO `verslai`(Savininkas, Pavadinimas, VerslasNupirktas, VersloFondas, VersloKaina)VALUES(%s,%s,%d,%d,%d)", GetPlayerNameEx(playerid), vInfo[V][VersloPavadinimas], vInfo[V][VerslasNupirktas], vInfo[V][VersloFondas], vInfo[V][VersloKaina]);
					Db = mysql_tquery(Db, query);


Re: Error with mysql INSERT - Stormalle - 19.08.2018

help!

Re: Error with mysql INSERT - Stormalle - 19.08.2018

okey i fixed it myself, dumb me forgot about ` and '