getting the select value

[eluser]CroNiX[/eluser]

Code:

public function getPageInfo($parentID)
{
  $sql = "select ID, CATEGORY_NAME from igs_page_category where CATEGORY_PARENT_ID in ($parentID)";
  $query = $this -> db -> query($sql,$parentID);
  if ($query -> num_rows() > 0)
  {
   foreach ($query->result_array() as $row)
   {
    $ctg_ids[$row['ID'] = $row['CATEGORY_NAME'];  //changed this
   }
   return $ctg_ids;
  }
}

Code:

//in the view
echo form_dropdown('ID', $ctg_ids, set_value('ID', 0));

will create the dropdown, it's options, select the current value (if form was submitted), or select whatever has the value of 0 if the form hasn't been submitted (a default value, like "Choose ID")