A_MYSQL Issue
#1

pawn Код:
new string2[500];
        format(string2, sizeof(string2),"UPDATE `ownedcars` SET Model = '%d', Location_X = '%f', Location_Y = '%f'
        , Location_Z = '%f', Angle = '%f', Color_1 = '%d', Color_2 = '%d', Owner = '%s', PlateSet = '%d', Plate = '%s'
        , Owned = '%d', Locked = '%d', Paintjob = '%d', Virtualworld = '%d', Component0 = '%d', Component1 = '%d'
        , Component2 = '%d', Component3 = '%d', Component4 = '%d', Component5 = '%d', Component6 = '%d', Component7 = '%d'
        , Component8 = '%d', Component9 = '%d', Component10 = '%d', Component11 = '%d', Component12 = '%d', Component13 = '%d'
        , SecurityCode = '%d'"
, CarInfo[idx][cModel], CarInfo[idx][cLocationx], CarInfo[idx][cLocationy], CarInfo[idx][cLocationz],
        CarInfo[idx][cAngle], CarInfo[idx][cColorOne], CarInfo[idx][cColorTwo], CarInfo[idx][cOwner], CarInfo[idx][cPlateSet],
        CarInfo[idx][cPlate], CarInfo[idx][cOwned], CarInfo[idx][cLock], CarInfo[idx][cPaintjob], CarInfo[idx][cVirWorld],
        CarInfo[idx][cComponent0], CarInfo[idx][cComponent1], CarInfo[idx][cComponent2], CarInfo[idx][cComponent3], CarInfo[idx][cComponent4],
        CarInfo[idx][cComponent5], CarInfo[idx][cComponent6], CarInfo[idx][cComponent7], CarInfo[idx][cComponent8], CarInfo[idx][cComponent9],
        CarInfo[idx][cComponent10], CarInfo[idx][cComponent11], CarInfo[idx][cComponent12], CarInfo[idx][cComponent13], CarInfo[idx][cCode]);
        mysql_query(string2);
Okay so after reading about saving SQL querys to a database, what did I do wrong there, looks fine to me?

pawn Код:
error 037: invalid string (possibly non-terminated string)
error 017: undefined symbol "UPDATE"
Reply


Messages In This Thread
A_MYSQL Issue - by UnknownGamer - 30.09.2013, 22:28
Re: A_MYSQL Issue - by BlackBank - 30.09.2013, 22:33
Re: A_MYSQL Issue - by UnknownGamer - 30.09.2013, 22:37
Re: A_MYSQL Issue - by Isolated - 30.09.2013, 22:46
Re: A_MYSQL Issue - by UnknownGamer - 30.09.2013, 23:37
Re: A_MYSQL Issue - by Jefff - 01.10.2013, 00:23
Re: A_MYSQL Issue - by UnknownGamer - 01.10.2013, 00:26
Re: A_MYSQL Issue - by Jefff - 01.10.2013, 00:29
Re: A_MYSQL Issue - by UnknownGamer - 01.10.2013, 00:31
Re: A_MYSQL Issue - by Jefff - 01.10.2013, 00:51

Forum Jump:


Users browsing this thread: 2 Guest(s)