evaoosyz

  include_once"include/sql.php";
  require_once "HTML/QuickForm.php";
 $sql ="SELECT * FROM `bug_big_cast` ORDER BY `ID` ASC  ";
 $sql2 ="SELECT * FROM `bug_s_cast` ORDER BY `ID` ASC   ";
 $conn=mysql_connect( $mysql_server_name, $mysql_username, $mysql_password );
 mysql_query("SET NAMES 'utf8'");
    mysql_query("SET CHARACTER_SET_CLIENT=utf8;");
    mysql_query("SET CHARACTER_SET_RESULTS=utf8;");
 $result=mysql_db_query( $mysql_database, $sql,$conn ); 
 $result2=mysql_db_query( $mysql_database, $sql2,$conn ); 
 $form = new HTML_QuickForm('frmTest','post','');
while($row=mysql_fetch_row($result))
{
$a["$row[1]"] = "$row[2]" ;
} 
mysql_free_result($result);
while($row=mysql_fetch_row($result2))
{
$b["$row[1]"]["$row[0]"] = "$row[2]";
} 
mysql_free_result($result2);
$sel =& $form->addElement('hierselect', 'location', 'MYSQL的資料:');
$sel->setOptions(array($a,$b));
$form->display();
?>