24.06.2012, 15:19
it wont give an error if sql syntax is wrong,
post what you changed,
heres how i insert!
post what you changed,
heres how i insert!
pawn Код:
//first i build my values to insert
format
(
Query_Values,
sizeof(Query_Values),
"'%i','%f','%f','%f','%f','%f','%f'",
gDBObjs[objectid][E_DB_OBJ_MODEL],
gDBObjs[objectid][E_DB_OBJ_X],
gDBObjs[objectid][E_DB_OBJ_Y],
gDBObjs[objectid][E_DB_OBJ_Z],
gDBObjs[objectid][E_DB_OBJ_RX],
gDBObjs[objectid][E_DB_OBJ_RY],
gDBObjs[objectid][E_DB_OBJ_RZ]
);
//then i build a query and append my Values from above to it
format(Query, sizeof(Query), "INSERT INTO OBJS (`MODEL`,`X`, `Y`, `Z`, `RX`, `RY`, `RZ`) VALUES(%s)", Query_Values);