[Dr.CustUmz]

ok now I want to relay those results back in an ordered manor

I have

$query = $db->query_first( "select * from redirect order by hits desc");
$result = MYSQL_QUERY($query);
$number = MYSQL_NUMROWS($result) or die (mysql_error());
$i = 0;

if ($number == 0) {
  print "Nothing here";
}

elseif ($number >= 1) {
  while ($i < $number){
    $hits = mysql_result($result,$i,hits);
    $url = mysql_result($result,$i,url);
    if ($hits < 100){
    $color = "$color100";
    }
    print "<div align=\"left\">";
    print "<table COLS=3 border=\"0\" width=\"100%\"><tr><td ALIGN=LEFT with=\"400\"><b><a
    href=\"$url\">$url</a></b></td>";
    print "<td ALIGN=right WIDTH=\"60\"><b>$hits</b></td>";
    print "<td align=left WIDTH=\"$hits\" BGCOLOR=\"$color\">&nbsp;</td></tr>";
    $i++;
    print "</table>\n";
  }
}

but again im having issues vbulletin(ifying) this, in red is the code i believe needs to be changed to work.