[Adamoneoone]

Thanks for the reply, i did that and it shows the correct amount of lines, however now the data shown isn't correct (the first line is duped) and i get the following in my logs:
cache_get_value_name_int: no active cache

pawn Code:

new rows;
    cache_get_row_count(rows);
    if(rows)
    {
        new target, hitprice;
        for(new i; i<rows; i++)
        {
            cache_get_value_int(i, "hitid", target);
            cache_get_value_int(i, "amount", hitprice);