Display a list

[krohnathlonman]

I want to display a list inside of a PHP page.

Here's my Query, I just want display the list.....

PHP Code:

      <?php
 
 $guide =    $DB_site->query("SELECT id, subject, subject_2 FROM amartin WHERE category  = 'guide' ORDER BY subject ASC");
 
     
     while (list ($id, $subject, $topic) = mysql_fetch_row($guide)) {
    echo "<tr><td width=50%><a href=articles.php?aid=$id&page=1&topic=$topic>$subject</a></td></tr>\n";
 
 }
 ?>

Whats the proper way of doing this in VBulletin?

[krohnathlonman]

Here's what I've got so far:

PHP Code:

 $pop =    $DB_site->query("SELECT id, subject FROM amartin ORDER BY views DESC LIMIT 5");
      while($popular = $DB_site->fetch_array($pop)) {
  
            $populars['subject'] = $popular['subject'];
              $populars['id'] = $popular['id'];
      }
  eval("\$popularbit .= \"".fetch_template('article_list_bit')."\";");
  
  eval("\$article[popular] = \"".fetch_template('article_pop')."\";");
      unset($popular);
      $DB_site->free_result($pop); 


What else Do I need for it to display the list? I only get the very last item of the list..... It's just not looping right what I miss?

[krohnathlonman]

anybody?

[NTLDR]

PHP Code:

eval("\$popularbit .= \"".fetch_template('article_list_bit')."\";"); 


The above line should be within the while loop