[Borg]

you can remove filter in your query. i.e. you can select all houses in one query and then load it one by one.
for example:

pawn Код:

new rows, field, IDH, str[120];
mysql_query("SELECT * FROM `house_info`");
...
new idx = 1;
while(mysql_retrieve_row())
{
    //now idx - your house id
    cache_get_data(rows, field, DB);
    if(!rows)
    {
        IDH = h;
        break;
    }
    idx++;
}
...