Help Please .. Please

[fewdox]

I Have This Script .. Why Show Only Players Of Top
How i can make to show 5 of ranking top ?

5 of rank rep
5 of rank level
5 of rank xp
5 of rank frags
5 of rank rep negative ?

//Queryes .. 
$query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`rep`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 10;')->fetch(); 
$query3 = $SQL->query('SELECT `players`.`experience`, `players`.`name` FROM `players` WHERE experience > 0;')->fetch(); 
$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 10;')->fetch(); 
$reputation = $SQL->query('SELECT `rep`, `name` FROM `players` WHERE `rep` > 0;')->fetch(); 
$reputation2 = $SQL->query('SELECT `rep`, `name` FROM `players` WHERE `rep` < 0;')->fetch(); 

 //End Of Queries 
$main_content .=' 
<table bgcolor='.$config['site']['darkborder'].' border=0 cellpadding=2 cellspacing=2 width=0%><tr bgcolor='. $config['site']['vdarkborder'] .'> 
<tr> 
    <td  bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Experience</b></td> 
    <td  bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Reputation</b></td> 
    <td  bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Reputation Negative</b></td> 
    <td  bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Frags</b></td> 
    <td  bgcolor='. $config['site']['vdarkborder'] .' align="center" class="white" colspan="" width="10%"><b>Top Level</b></td> 
</tr> 
<tr> 
    <td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['experience']).')</td> 
    <td align="top"><b><font size="1">'.$reputation['name'].'</font> <font color="red" font size="1">('.$reputation['rep'].')</font></td> 
    <td align="top"><b><font size="1">'.$reputation2['name'].'</font> <font color="red" font size="1">('.$reputation2['rep'].')</font></TD> 
    <td align="top"></TD> 
    <td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['level']).')</td> 
</tr> 
<tr> 
  <td align="top"><b>'.$query3['name'].'</b>('.urlencode($query['experience']).')</td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
</tr> 
<tr> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
</tr> 
<tr> 
  <td align="top"><b>'.$query['name'].'</b> ('.urlencode($query['experience']).')</td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
  <td align="top"></td> 
</tr> 
</table>'; 
// END END END END END END END

 

[xmp3]

because you use fetch() instead of fetchAll() I don't see also any kind of loop here.

try something like

$query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 10;')->fetchAll(); 
foreach($query2 as $row)
{
  echo $row['name'];
}

fit it to your needs

 

[fewdox]

where i paste it ?

 

[xmp3]

You don't understand. You need to loop the results in foreach for example. Now you are only showing 1 result from each query. It does not matter that query returns more because you are fetching only one.

 

[fewdox]

xmp3 add me msn

[email protected]

 

[fewdox]

not worked .. not showing the results in table