function enhanced_list_box($options){ 

require_once ('../../mysql_connect.php'); // connects to the database 

  $sql  = "select " . $options['id_field']; 
  $sql .= ", " . $options['value_field']; 
  $sql .= " from " . $options['table']; 

  //append any where criteria to the sql 
  if(isset($options['where_statement'])) { 
    $sql .= " where " . $options['where_statement'] ; 
  } 

  //  set the sort order of the list 
  $sql .= " order by " . $options['value_field']; 

  $result = mysql_query($sql) 
            or die("error in SQL"); 

echo '<select name="', $options['id_field'], '" size="1">'; 

while ($row = mysql_fetch_array($result, MYSQL_NUM)) 
{ 
  if($row[0] == $options['highlight_id']) { 
    echo '<option value="', $row[0], '" SELECTED>', 
         $row[1], '</option>'; 
  } else { 
    echo '<option value="', $row[0], '">', 
         $row[1], '</option>'; 
  } 
} 

echo '</select>'; 
}