[[MG]Dimi]

I got in problem to select multiple row' info from MySQL. I need to get Top 5 players' names and score but my Query get's only the first one.

pawn Код:

query("SELECT `Username`,`Score` FROM `Users` ORDER BY `Users`.`Score` DESC LIMIT 0, 5");

Anyone have any idea?

[Hiddos]

pawn Код:

query("SELECT `Username`,`Score` FROM `Users` ORDER BY `Score` DESC LIMIT 5");

Try that?

[[MG]Dimi]

Nope, doesn't work.

[Richie©]

The query Hiddos gave you should be correct, try sending that query in phpmyadmin and see the result.

[[MG]Dimi]

It returns in phpMyAdmin but when I query it from ingame in mysql_debug file I see it only returned First player. I will try once again. Then we will see.

[Vince]

You are not fetching the rows in a loop then. The retrieval functions can only work one row at a time.

[[MG]Dimi]

Can you give me example then?

[Macluawn]

pawn Код:

new result[128],
    idx;
mysql_query("SELECT * FROM table");
mysql_store_result();
while(mysql_fetch_row_format(result) == 1)
{   
    sscanf(result, "p<|>dddd", id, food, salt, spoon);
    Array[idx] = food;
    idx++;
}
mysql_free_result();

[[MG]Dimi]

Ok. It works. Thanks Guys