Battle Tent error (Order of assending)

[EineyEntertainment]

I was wondering if anyone could show me how to change around my battle tent so the NPC's are displayed in order of money earned or level. Here's the code with the changes I've added so far :)

 

<?php
include "globals.php";
print "<h3>Halls of Heros</h3>
[b]Welcome to the Halls of Heros! Here you can challenge the Greek Legends  for money and fame.[/b]
<table width=100% cellspacing=1 class='table'><tr style='background: gray; '><th>Hero's Name</th><th>Level</th><th>Times bested</th><th>Ready To Be Challenged?</th><th>Location</th><th>Money Won</th><th>Challenge</th></tr>";
$q=$db->query("SELECT cb.*,u.*,c.npcid,cy.cityname FROM challengebots cb LEFT JOIN users u ON cb.cb_npcid=u.userid LEFT JOIN challengesbeaten c ON c.npcid=u.userid AND c.userid=$userid LEFT JOIN cities cy ON u.location=cy.cityid");
while($r=$db->fetch_row($q))
{
$earn=$r['cb_money'];
$v=$r['userid'];
$q2=$db->query("SELECT count(*) FROM challengesbeaten WHERE npcid=$userid");
$times=$db->fetch_single($q2);
print "<tr><td>{$r[username]}</td><td>{$r['level']}</td><td>$times</td><td>";
if($r['hp'] >= $r['maxhp']/2 and $r['location']==$ir['location'] and !$ir['hospital'] and !$ir['jail'] and !$r['hospital'] and !$r['jail']) { print "<font color=green>Yes</font>"; } else { print "<font color=red>No</font>"; }
print "</td><td>{$r['cityname']}</td><td>$earn</td><td>";
if($r['npcid'])
{
print "[i]Already[/i]";
}
else
{
print "[url='attack.php?ID={$r[']Challenge[/url]";
}
print "</td></tr>";
}
print "</table>";
$h->endpage();
?>

 

Edit: just added the SQL Id's :) it wasn't ordering right in there. TY for looking. Good to close topic or trash if you guys want :)

[Karlos]

Re: Battle Tent error (Order of assending)

DESC `cb_money`

:wink: