[IdonTmiss]

I have a house system in MySQL, and when I create a house it loops thorught out all houses and checks the next loop

PHP код:

stock House_Next() {
       new number= -1;
    for(new i = 1; i < sizeof(HouseInfo); i++) {
        if(HouseInfo[i][h_Created] == false) {
            number= i;
            break;
        }
    }
    return broj;
} 


But If i delete a house using the standard query "DELETE * FROM `houses` WHERE `sqlid` blbal" the next house will be ID: 5 ingame but ID 6 in sql can i fix that somehow or?