Check this

#include <YSI\y_iterate>

new Iterator:Factions<MAX_FACTIONS>;

// OnGameModeInit and OnGameModeExit =  Iter_Clear(Factions);

CMD:fcreate(playerid, params[])
{
    new string[128], query[400], fname[32];
    if(sscanf(params, "s[32]", fname)) return SendClientMessage(playerid, -1, "USAGE: /fcreate factionname");
    // GETTING ALL THE FACTIONS CREATED, THEN ADDING 1 TO MAKE THE NEW ONE
    new Total_Factions_Created = Iter_Free(Factions);
    //=====================================================================

    // THIS SETS THE FACTIONS NAME TO WHATEVER YOU JUST NAMED IT, PLUS SETS THE ID FOR THE FACTION
    Factions[Total_Factions_Created][ID] = Total_Factions_Created;
    format(Factions[Total_Factions_Created][Name], 64, "%s", fname);
    //==============================================================================================

    // THIS IS JUST TELLING YOU CREATED A FACTION, WITH THE NAME
    format(string, sizeof(string), "You have created a faction named: %s(ID:%d).",Factions[Total_Factions_Created][Name], Factions[Total_Factions_Created][ID]);
    SendClientMessage(playerid, -1, string);
    //================================================================================================

    // THIS IS SETTING ALL THE FACTION NAMES, WILL BE USED LATER FOR EDITTING AROUND
    format(Factions[Total_Factions_Created][Rank1], 32, "Rank 1 - Lowest");
    format(Factions[Total_Factions_Created][Rank2], 32, "Rank 2");
    format(Factions[Total_Factions_Created][Rank3], 32, "Rank 3");
    format(Factions[Total_Factions_Created][Rank4], 32, "Rank 4");
    format(Factions[Total_Factions_Created][Rank5], 32, "Rank 5 - Leader");
    //================================================================================

    // THIS IS FOR SAVING ALL THE DATA INTO THE MYSQL DATABASE
    format(query, sizeof(query), "INSERT INTO `Factions` (ID, Name, Rank1, Rank2, Rank3, Rank4, Rank5) VALUES(%d,'%s','%s','%s','%s','%s','%s')",

                        Factions[Total_Factions_Created][ID], Factions[Total_Factions_Created][Name],
                        Factions[Total_Factions_Created][Rank1],Factions[Total_Factions_Created][Rank2],
                        Factions[Total_Factions_Created][Rank3],Factions[Total_Factions_Created][Rank4],
                        Factions[Total_Factions_Created][Rank5]);
    mysql_query(Database,query);

    Iter_Add(Factions,Total_Factions_Created);
    //=================================================================================
    return 1;
}