<?php

 print "<select name='category'>";

  $selcat="SELECT * from cl_categories order by CatName ASC";

  $selcat2=mysql_query($selcat) or die("Could not select category");

  traverse(0,0,$selcat2);

  print "</select><br>";

?>

<?php

function traverse($root, $depth, $sql) 

{ 

     $row=0; 

     while ($acat = mysql_fetch_array($sql)) 

     { 

          if ($acat['CatParent'] == $root) 

          { 

               print "<option value='" . $acat['CatID'] . "'>"; 

               $j=0; 

               while ($j<$depth) 

               {     

                     print "&nbsp;&nbsp;";

                    $j++; 

               } 

               if($depth>0)

               {

                 print "-";

               }

               print $acat['CatName'] . "</option>"; 

               mysql_data_seek($sql,0); 

               traverse($acat['CatID'], $depth+1,$sql); 

                

          } 

          $row++; 

          mysql_data_seek($sql,$row); 

           

     } 

} 

?>

// build combo box options

$list = '';

foreach ($categories as $key => $value) {

	$name     = $value['name'];

	$children = $value['children'];

	

	$list .= "<optgroup label=\"$name\">"; 

	

	foreach ($children as $child) {

		$list .= "<option value=\"{$child['id']}\"";

		

		if ($child['id'] == $cat_id) {

			$list .= " selected";

		}

		$list .= ">{$child['name']}</option>";

	}

	

	$list .= "</optgroup>";

}