[Kaperstone]

How about simple solution such as temporary holder ?
create a new array with roughly the same size as ClanDB, insert data into it and then create another loop where you switch data between them like so

pawn Code:

new fixer[][];

for(new i=0;i<rows;i++) {fixer=mysql}

for(new i=0;i<rows;i++) {
    ClanDB[fixer[i][ClanID]][name]=fixer[i][name];
}