SQL issue.
#1

I'm having a small problem with a query, not actually inserting the data into the database.


pawn Код:
format(Query, sizeof(Query), "UPDATE `PlayerVehicles` SET `Mod1`=%d, `Mod2`=%d, `Mod3`=%d, `Mod4`=%d, `Mod5`=%d, `Mod6`=%d, `Mod7`=%d, `Mod8`=%d, `Mod9`=%d, `Mod10`=%d,\
    `Mod11` = %d, `Mod12`=%d, `Mod13`=%d, `Mod14`=%d, `Mod15`=%d, `Mod16`=%d, `Mod17` WHERE `OwnedVehicleID` = %i LIMIT 1"
,
    Vehicles[iVehicleID][mod1],
    Vehicles[iVehicleID][mod2],
    Vehicles[iVehicleID][mod3],
    Vehicles[iVehicleID][mod4],
    Vehicles[iVehicleID][mod5],
    Vehicles[iVehicleID][mod6],
    Vehicles[iVehicleID][mod7],
    Vehicles[iVehicleID][mod8],
    Vehicles[iVehicleID][mod9],
    Vehicles[iVehicleID][mod10],
    Vehicles[iVehicleID][mod11],
    Vehicles[iVehicleID][mod12],
    Vehicles[iVehicleID][mod13],
    Vehicles[iVehicleID][mod14],
    Vehicles[iVehicleID][mod15],
    Vehicles[iVehicleID][mod16],
    Vehicles[iVehicleID][mod17],
    iVehicleID);

    mysql_query(Query);
That there, doesn't insert the above items into the actual table.
Reply


Messages In This Thread
SQL issue. - by iGetty - 01.12.2012, 09:55
Re: SQL issue. - by Konstantinos - 01.12.2012, 10:08
Re: SQL issue. - by iGetty - 01.12.2012, 11:06
Re: SQL issue. - by Konstantinos - 01.12.2012, 11:16
Re: SQL issue. - by Ballu Miaa - 01.12.2012, 11:32
Re: SQL issue. - by iGetty - 01.12.2012, 11:34
Re: SQL issue. - by Konstantinos - 01.12.2012, 11:39
Re: SQL issue. - by iGetty - 01.12.2012, 11:40
Re: SQL issue. - by iGetty - 01.12.2012, 12:04
Re: SQL issue. - by Ballu Miaa - 02.12.2012, 06:21

Forum Jump:


Users browsing this thread: 3 Guest(s)