MySQL - Query not storing data
#5

This is a common mistake people make with mysql,

Код:
format(query,sizeof(query), "INSERT INTO `VehicleKeys` (ID,VehicleID,Linked) VALUES('%d','%d','%s','%d')",i,car,playerid);
That is incorrect, it should be this:

Код:
format(query,sizeof(query), "INSERT INTO `VehicleKeys` (ID,VehicleID,Linked) VALUES('%d','%d','%s','%d');",i,car,playerid);
Notice, you forgot the ";" after you close the values bracket.. it makes all the difference..
Reply


Messages In This Thread
MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 07:58
Re: MySQL - Query not storing data - by JaTochNietDan - 28.06.2012, 08:09
Re: MySQL - Query not storing data - by Baboon - 28.06.2012, 08:09
Re: MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 12:20
Re: MySQL - Query not storing data - by phillip875 - 28.06.2012, 13:32
Re: MySQL - Query not storing data - by Deal-or-die - 28.06.2012, 13:38
Re: MySQL - Query not storing data - by iGetty - 28.06.2012, 13:39

Forum Jump:


Users browsing this thread: 3 Guest(s)