[Dragony92]

What happen with cache if i select few rows, and than i send new queries while i'm taking the data from that rows in loop...
Example code..

pawn Код:

mysql_tquery(mysql, "SELECT * FROM table", "SortData");

public SortData()
{
    for(i = 0; i < cache_get_row_count(); i++)
    {
        ...
        mysql_tquery(...);
        ...
    }
    return 1;
}

Do i lose cache from first query if i call a new one?

[Dragony92]

BUMP

[Vince]

Not entirely sure, but what is it that you're trying to do? This function makes me think that the entire action should be handled by MySQL rather than in Pawn.

[Dragony92]

Getting data, analyzing, doing actions on server and then updating database...

[Dragony92]

BUMP