1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

<?php        header("Content-Type: text/plain; charset=utf-8");
            header("Cache-Control: no-cache,must-revalidate");
            header("Prdgma : no-cache");
            include('phpconfig.php');
            //----------------------------------------------------------
            $query="SELECT a.* , b.home_type_name FROM `tbl_home_data` a "
            ." LEFT JOIN `tbl_home_type` b ON a.home_type_id=b.id "
            ." WHERE a.project_id     ='".$_POST['projectID']."' ORDER BY b.home_type_name ASC ";
            $result=mysql_query($query);
?>
        

        <img src="images/icon/Service.png" alt="" />&nbsp; <select name="HomeTypeID" style="width:230px;" >
          <option value="" selected="selected">{ เลือกประเภทที่อยู่ }</option>
         <?php while($data=mysql_fetch_assoc($result)){?> <option value="<?php echo $data['id']?>"><?php echo $data['home_type_name']?></option><?php } ?>>
        </select>

<?php mysql_close();?>