MYSQL Query doesn't load all rows
#1

I have a problem with my MYSQL query. The query doesn't load all the rows stated below. The rows are named correctly, everything is correct.
code:
pawn Код:
format(query, sizeof(query), "SELECT `kills`,`deaths`,`points`,`infpoints` FROM `users` WHERE `username` = '%s'", PlayerName(playerid));
    mysql_query(query);
    mysql_store_result();
    if(mysql_fetch_row_format(query))
    {
    sscanf(query, "p<|>iiii", Kills[playerid], Deaths[playerid], Points[playerid], FPoints[playerid]);
    printf("Selected %d rows", mysql_num_rows());
    } else {
        print("Nothing found");
    }
It loads only one row, and I think that row is called "kills".

I hope you can help me.
Reply


Messages In This Thread
MYSQL Query doesn't load all rows - by Biesmen - 29.04.2011, 12:09
Re: MYSQL Query doesn't load all rows - by JaTochNietDan - 29.04.2011, 12:11
Re: MYSQL Query doesn't load all rows - by Biesmen - 29.04.2011, 12:14
Re: MYSQL Query doesn't load all rows - by JaTochNietDan - 29.04.2011, 12:15
Re: MYSQL Query doesn't load all rows - by Biesmen - 29.04.2011, 12:16

Forum Jump:


Users browsing this thread: 3 Guest(s)