How to load a selectbox in admincp page?

[TalkVirginia]

I have a admincp page to add new categories to a mod I'm working on. I'm using the following code but it doesn't seem to be working quite right:

PHP Code:


  $strSQL = "SELECT Cats3.CatId, Cats.Cat, Cats1.Cat, Cats2.Cat, Cats3.Cat ";
  $strSQL .= "FROM vb_bdcategories As Cats3 ";  
  $strSQL .= "LEFT JOIN vb_bdcategories As Cats2 ON Cats3.ParentId = Cats2.CatId "; 
  $strSQL .= "LEFT JOIN vb_bdcategories As Cats1 ON Cats2.ParentId = Cats1.CatId "; 
  $strSQL .= "LEFT JOIN vb_bdcategories As Cats ON Cats1.ParentId = Cats.CatId "; 
  $strSQL .= "WHERE Cats.ParentId is NULL "; 
  $strSQL .= "ORDER BY Cats.Cat, Cats1.Cat, Cats2.Cat, Cats3.Cat"; 

  $result = $db->query_read($strSQL);

  $a = $db->fetch_array($result);        

  print_form_header('adminbizindex.php');
  construct_hidden_code('CatID', 'CatID');
  print_table_header('Add Category');
  print_input_row('Category Name', 'Cat', 'Cat');
  print_select_row('Parent Category','ParentId',  $a, -1);
  print_submit_row("Submit"); 


All that is showing up in the selectbox are the first two fields. The id and the name.

Anyone have a suggestion? or tutorial I can read?

Thanks!

[Dismounted]

You need to loop through the result of the query and construct an array with id => value pairs.