SA-MP Forums Archive
Lost data in a query - 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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Lost data in a query (/showthread.php?tid=240257)



Lost data in a query - Hornet600 - 15.03.2011

Sometimes i lost data from a query to insert to values to mymsql db here is my query
pawn Код:
new query[256];
format(query, sizeof(query), "INSERT INTO vehicles (carid,Model,Color1,Color2, Locationx, Locationy,Locationz,Angle,Owner,Name) VALUES (NULL, %d, %d, %d,%f, %f, %f, %f,'%s','%s');",model, color1, color2, X, Y, Z, A, name1,name);
mysql_query(query);
Is there any way to make it never happen? all help apreciated :')


Re: Lost data in a query - randomkid88 - 15.03.2011

What do you mean lost data? Use mysql_debug(); and read some of the log. It could be that your query isn't long enough for what you're trying to do.