<?   
echo "<font id=groupitem><select id='brandcategory_ref_category_edit01'>";
echo "<option value='0'>============</option>" ;
echo "</select></font>";
?>

<? 
echo "<font id=category><select id='brandcategory_ref_category_edit01'>";
echo "<option value='0'>==== none ====</option>" ;
echo "</select></font>";
?>

<?
echo "<font id=brand><select id='brandcategory_ref_brand_edit01'>";
echo "<option value='0'>==== none ====</option>" ;
echo "</select></font>";
?>

<?
//set IE read from page only not read from cache
header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");

header("content-type: application/x-javascript; charset=tis-620");

$id_edit=$_GET['id_edit'];
$data=$_GET['data'];
$val=$_GET['val'];

//set database
include "connet.php";

$sql_chk="select * from tb_brandcategory where brandcategory_id='$id_edit' ";
mysql_query('SET CHARACTER SET tis620');
mysql_query('SET collation_connection = "tis620_thai_ci"');
$result_chk=mysql_db_query($dbname,$sql_chk);
$rs_chk=mysql_fetch_array($result_chk);

$ref_brand=$rs_chk[brand_id];
$ref_category=$rs_chk[category_id];
$ref_groupitem=$rs_chk[groupitem_id];

if ($data=='groupitem') {  // first dropdown
echo "<select name='groupitem' id='brandcategory_ref_groupitem_edit01' onChange="dochange('category', this.value)">";
echo "<option value='0'>==== กลุ่มสินค้า ====</option>";
$sql="select `groupitem_id`, `groupitem_name_th` from tb_groupitem order by `groupitem_id`";
mysql_query('SET CHARACTER SET tis620');
mysql_query('SET collation_connection = "tis620_thai_ci"');
$result=mysql_db_query($dbname,$sql);
while($rs=mysql_fetch_array($result)){
$groupitem_id=$rs[groupitem_id];
$groupitem_name_th=$rs[groupitem_name_th];
if ($ref_groupitem==$groupitem_id) {
echo "<option value='$groupitem_id' selected>$groupitem_name_th</option>";
} else { 
echo "<option value="$groupitem_id" >$groupitem_name_th</option>" ;
}
}
} else if ($data=='category') { // second dropdown
echo "<select name='category' id='brandcategory_ref_category_edit01' onChange="dochange('brand', this.value)">";
echo "<option value='0'>==== ประเภทสินค้า ====</option>";                         
$sql_cat="select `category_id`, `category_name_th` FROM tb_category WHERE `groupitem_id` = '$val' ORDER BY `category_id` ";
mysql_query('SET CHARACTER SET tis620');
mysql_query('SET collation_connection = "tis620_thai_ci"');
$result_cat=mysql_db_query($dbname,$sql_cat);
while($rs_cat=mysql_fetch_array($result_cat)){     
$category_id=$rs_cat[category_id];
$category_name_th=$rs_cat[category_name_th];  
if ($ref_category==$category_id) {
echo "<option value='$category_id' selected>$category_name_th</option>";
} else { 
echo "<option value="$category_id" > $category_name_th</option>" ;
}
}
} else if ($data=='brand') { // second dropdown
echo "<select name='brand' id='brandcategory_ref_brand_edit01'>";
echo "<option value='0'>==== ยี่ห้อสินค้า ====</option>";                         
$sql_bra="select `brand_id`, `brand_name_th` FROM tb_brand  ORDER BY `brand_id` ";
mysql_query('SET CHARACTER SET tis620');
mysql_query('SET collation_connection = "tis620_thai_ci"');
$result_bra=mysql_db_query($dbname,$sql_bra);
while($rs_bra=mysql_fetch_array($result_bra)){     
$brand_id=$rs_bra[brand_id];
$brand_name_th=$rs_bra[brand_name_th];  
if ($ref_brand==$brand_id) {
echo "<option value='$brand_id' selected>$brand_name_th</option>";
} else {   
echo "<option value="$brand_id" > $brand_name_th</option>" ;
}
}
}
echo "</select>";
?>