[solved] php/mysql issue

[Dr.CustUmz]

as my initial question in my previous issue was solved i decided to open a new thread to avoid hijacking my own thread.

this is only part of the code, but im having issues getting this to work with vbulletin

PHP Code:

$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 "<CENTER><P><b>No Links tracked yet!</b></CENTER>";
}

  ELSEIF ($number >= 1) {
        WHILE ($i < $number){
                $hits = mysql_result($result,$i,hits);
                $url = mysql_result($result,$i,url);
                if ($hits < 10){