проблем с РНР код

[baiumbg]

Имам проблем с този код:

echo '<h2> PVP Rankings Top ' . $limit . '</h2><br>';
$count = 0;

$pvp = array();
$charname = array();

$result = mysql_query("SELECT * FROM characters WHERE accesslevel=0 ORDER BY level DESC LIMIT 0, " . $limit . "");
while ($row = mysql_fetch_array($result))
{

$pvp[] = $row['pvpkills'];
$charname[] = $row['char_name'];
$count++;

}

$loop = 0;
while ($loop < $count)
{
echo $loop+1 . ": " . $charname[$loop] . ' with ' . $pvp[$loop] . ' PVP Kills<br>';
$loop++;
}

echo '<br>';

Изкарва ми ги така:

1: IIPKIICastravet3 with 0 PVP Kills
2: HgH with 0 PVP Kills
3: BerSeker with 0 PVP Kills
4: LordSiluos with 4 PVP Kills
5: HearT with 0 PVP Kills
6: KillNooB with 6 PVP Kills
...

 

[heminei]

А как трябва да ти ги изкарва?

 

[baiumbg]

трябва да ги подреди по pvpkills

 

[heminei]

echo '<h2> PVP Rankings Top ' . $limit . '</h2><br>';
$count = 0;

$pvp = array();
$charname = array();

$result = mysql_query("SELECT * FROM characters WHERE accesslevel=0 ORDER BY pvpkills DESC LIMIT 0, " . $limit . "");
while ($row = mysql_fetch_array($result))
{

$pvp[] = $row['pvpkills'];
$charname[] = $row['char_name'];
$count++;

}

$loop = 0;
while ($loop < $count)
{
echo $loop+1 . ": " . $charname[$loop] . ' with ' . $pvp[$loop] . ' PVP Kills<br>';
$loop++;
}

echo '<br>';

така?

 

[baiumbg]

много съм тъп >.< мерси бях ги подредил по левел