mysql | 嵌套设置为选择框

Question

I have nested set table (Joomla categories table):

id parent_id  lft rgt extension title
1  0          0   19  system    ROOT
...
12 1          3   6   com_hi    Category1
13 12         4   5   com_hi    Category2

How it is possible to convert this data into select box?

<select>
   <option value="12">Category1</option>
   <option value="13">...Category2</option>
</select>  

Answer 1

  $query= mysql_query('select * from table');
   //select your table first

   echo "<select>";
 // and in your while loop do this code.. 
   while($row = mysql_fetch_array($query))
    {
        echo "<option value=".$row['id']. " > ". $row['title'] ."</option>";
    }
   echo "</select>";