Top command (again)
#4

It can store only 1 query with mysql_store_result.

Just do that with this way:
pawn Код:
mysql_query("SELECT user, Scores FROM `playerdata` ORDER BY `Scores` DESC LIMIT 5");
mysql_store_result();
// assign..
mysql_free_result();

mysql_query("SELECT user, Deaths FROM `playerdata` ORDER BY `Deaths` DESC LIMIT 5");
mysql_store_result();
// assign..
mysql_free_result();

mysql_query("SELECT user, Cash FROM `playerdata` ORDER BY `Cash` DESC LIMIT 5");
mysql_store_result();
// assign..
mysql_free_result();

mysql_query("SELECT user, Exp FROM `playerdata` ORDER BY `Exp` DESC LIMIT 5");
mysql_store_result();
// assign..
mysql_free_result();

// show dialog..
Reply


Messages In This Thread
Top command (again) - by Face9000 - 05.01.2014, 23:28
Re: Top command (again) - by Eth - 05.01.2014, 23:44
Re: Top command (again) - by Face9000 - 06.01.2014, 09:53
Re: Top command (again) - by Konstantinos - 06.01.2014, 10:02
Re: Top command (again) - by Face9000 - 06.01.2014, 10:52
Re: Top command (again) - by Konstantinos - 06.01.2014, 10:55
Re: Top command (again) - by Face9000 - 06.01.2014, 12:16
Re: Top command (again) - by Face9000 - 07.01.2014, 18:18
Re: Top command (again) - by Face9000 - 08.01.2014, 20:32
Re: Top command (again) - by Vince - 08.01.2014, 20:42

Forum Jump:


Users browsing this thread: 1 Guest(s)