Error in Query?
#1

When I do /vehpos to save the vehicles position, I get this.

Код:
[16:42:06] 1|562|1764.76|-1854.28|13.4141|285.53|3|3|6000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0
[16:42:06] Number of vehicle models: 1
[16:43:22] MySQL Error (0): Could not execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `VEHid` = '1'' at line 1.
This is under UpdateVehicleInfo()

pawn Код:
format(string, sizeof(string), "UPDATE `vehicles` SET `VEHid` = '%d', `model` = '%d', `park_x` = '%f', `park_y` = '%f', `park_z` = '%f', `park_o` = '%f' WHERE \
    `VEHid` = '%d'"
, VehicleInfo[vehicleid][vVEHid], VehicleInfo[vehicleid][vModel], \
    VehicleInfo[vehicleid][vPark_x], VehicleInfo[vehicleid][vPark_y], VehicleInfo[vehicleid][vPark_z], VehicleInfo[vehicleid][vPark_o], VehicleInfo[vehicleid][vVEHid]);
    mysql_query(string);
Reply


Messages In This Thread
Error in Query? - by Antonio [G-RP] - 12.01.2011, 23:44
Re: Error in Query? - by Anthonyx3' - 12.01.2011, 23:49
Re: Error in Query? - by Antonio [G-RP] - 12.01.2011, 23:52
Re: Error in Query? - by coole210 - 13.01.2011, 03:24
Re: Error in Query? - by PeteShag - 13.01.2011, 05:23

Forum Jump:


Users browsing this thread: 2 Guest(s)