Hey, ich habe gerade versucht meine Fraktionsdaten mit MySql zu laden aber ich bekomme in der Console Error...
Woran liegt das?....
Code:
for(new i; i<MAX_FRAKTION; i++)
{
new Query[500];
format(Query,500,"Insert INTO `Fraktiondaten` SET `Kasse`='%d',`Armour`= '%d',`Colt`='%d',`Silenced`='%d', `Deagle`='%d',`Shotgun` = '%d', `Shotgun` = '%d', `Uzi` = '%d', `MP5` = '%d', `Tec` = '%d', `AK` = '%d', `M4` = '%d', `Sniper` = '%d', `RPG`='%d', `Javelin`='%d' WHERE `FrakID`='%i'",
FrakInfo[i][fKasse],FrakInfo[i][fArmour],FrakInfo[i][fColt],FrakInfo[i][fSilenced],FrakInfo[i][fDeagle],FrakInfo[i][fShotgun],FrakInfo[i][fCShotgun],FrakInfo[i][fUzi],FrakInfo[i][fMP5],FrakInfo[i][fTec],FrakInfo[i][fAK],FrakInfo[i][fM4],FrakInfo[i][fSniper],FrakInfo[i][fRPG],FrakInfo[i][fJavelin],i);
mysql_query(Query);
}
Error in der Console:
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='0'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='1'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='2'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='3'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='4'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='5'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='6'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='7'' at line 1.
[15:30:49] [MySQL] Error (0): Failed to exeute 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 `FrakID`='8'' at line 1.