<?php require_once('../Connections/BE2.php'); 
 
$tb1='1';
 
if(isset($_POST['tb1'])){ $tb1=$_POST['tb1']; }



 if($tb1==2){
   $query_Rct2 = "SELECT * FROM travel where tbc='旅遊網' AND tb3='Y' order by tbindex" ; 
 }else{
   $query_Rct2 = "Select kid as tb0,kdoc as tb2 FROM company_kinds where kflag='Y' order by kindex" ; 	 
 }
 
// address_id county district street
 mysql_select_db($database_BE2, $BE2);
$result = mysql_query($query_Rct2, $BE2) or die(mysql_error());
$response=''; 
   while($row = mysql_fetch_assoc($result)) {
      $response .= '<option value="' .$row['tb0'] . '">' . $row['tb2'] . '</option>'; 
   }
echo $response;
mysql_free_result($result);
?>