MySql Insert into two tables
#1

Can i have two format strings in one query?
pawn Код:
format(query,sizeof(query), "INSERT INTO `Vehiclekeys` (ID,Vehicle,Linked,Type) VALUES '%d','%d','%s','%d')",i,
                    format(query,sizeof(query), "INSERT INTO `Vehicles` (ID,VehicleID,ModelID,PositionX,PositionY,PositionZ,AngleZ,Color1,Color2,Plate) VALUES('%d','%d','%d', '%f','%f','%f','%f','%d','%d','%s')",i,car,model,x,y,z,a,c1,c2,DEFAULT_PLATE);
                    mysql_query(query);
EDIT:

Nevermind, solved
Reply


Messages In This Thread
MySql Insert into two tables - by Deal-or-die - 02.05.2012, 14:27

Forum Jump:


Users browsing this thread: 1 Guest(s)