[new121]

I am making a clan system using sqlite. Everything is saving correctly but when it loads it only loads data from the first row.Anyone see why that is?

pawn Код:

new DBResult:qResult, query[256];
    //format(query,sizeof(query),"SELECT * FROM `Clans` WHERE `ID` = '%d'",d);
    qResult = db_query(gangs,"SELECT * FROM `Clans`");
    if(db_num_rows(qResult))
    {
        new Field[128];
        db_get_field_assoc(qResult, "ID", Field, 12);
        new i = strval(Field);

        db_get_field_assoc(qResult, "Name", Field, 32);
        strmid(gInfo[i][gName],Field,0,32);

        db_get_field_assoc(qResult, "Members", Field, 12);
        gInfo[i][gMembers] = strval(Field);

        db_get_field_assoc(qResult, "Color", Field, 32);
        strmid(gInfo[i][gColor],Field,0,32);

        db_get_field_assoc(qResult, "Leader", Field, MAX_PLAYER_NAME);
        printf("%s",Field);
    }
    db_free_result(qResult);