[jameskmonger]

I couldn't put the whole query in to one line as I got an error, I do this and it only inserts the data up to "Rank4Name".

pawn Код:

new string[256];
    format(string, sizeof(string), "INSERT INTO groups (ID,Name,Rank1Name,Rank2Name,Rank3Name,Rank4Name) VALUES ('%d','%s','%s','%s','%s','%s')", rows += 1, GroupCreating[playerid][Name], GroupCreating[playerid][Rank1Name], GroupCreating[playerid][Rank2Name], GroupCreating[playerid][Rank3Name], GroupCreating[playerid][Rank4Name]);
    mysql_query(string);

    format(string, sizeof(string), "INSERT INTO groups (Rank5Name,Rank6Name,Rank7Name,Rank8Name,JoinRank) VALUES ('%s','%s','%s','%s','%d') WHERE Name='%d'", GroupCreating[playerid][Name], GroupCreating[playerid][Rank5Name], GroupCreating[playerid][Rank6Name], GroupCreating[playerid][Rank7Name], GroupCreating[playerid][Rank8Name], GroupCreating[playerid][JoinRank]);
    mysql_query(string);

[Scenario]

Check your MySQL error log file.

[jameskmonger]

Mind telling me where to find that? I'll have a look but this is the first time I've ever touched SQL.

[dice7]

WHERE Name='%d'"


Your name is an integer ?

[jameskmonger]

Dice, that hasn't fixed it.

[dice7]

Could you show the (formated) queries and any errors in your error log ?

[Scenario]

Which MySQL plugin are you using?

[jameskmonger]

I am using G-Stylezzz' plugin. I have edited my queries to these:

pawn Код:

format(string, sizeof(string), "INSERT INTO groups (ID,Name,Rank1Name,Rank2Name,Rank3Name,Rank4Name) VALUES (%d,'%s','%s','%s','%s','%s')", groupID, GroupCreating[playerid][Name], GroupCreating[playerid][Rank1Name], GroupCreating[playerid][Rank2Name], GroupCreating[playerid][Rank3Name], GroupCreating[playerid][Rank4Name]);
    mysql_query(string);

    format(string, sizeof(string), "INSERT INTO groups (Rank5Name,Rank6Name,Rank7Name,Rank8Name,JoinRank) VALUES ('%s','%s','%s','%s',%d)", GroupCreating[playerid][Rank5Name], GroupCreating[playerid][Rank6Name], GroupCreating[playerid][Rank7Name], GroupCreating[playerid][Rank8Name], GroupCreating[playerid][JoinRank]);
    mysql_query(string);

And now it splits like so:

[Calgon]

What types for your fields did you set?

[Hiddos]

What if you use the 'UPDATE' syntax for the second query?