|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_eoffice/application/event_calendar/manager/ |
Upload File : |
<?
header ("Content-Type: text/html; charset=tis-620");
include("../../../config/config.inc.php");
//Excute Query from section
//$sql = "select id, detail from manager where status_m = '1'";
$xdiv=$_GET['xdiv'];
$xdis=$_GET['xdis'];
$xdef=$_GET['xdef'];
$sql = "select staffid, staffname ,staffsurname,title from epm_staff inner join main_menu_owner on epm_staff.staffid=main_menu_owner.owner_id where main_menu_owner.main_menu_id='$xdiv'"; //
//ดังมาเฉพาะกลุ่มที่เป็นผู้บริหารของระบบ
echo' <select id ="staffid" name="staffid" class="input" style="width:300px;" $xdis ><option selected value="">- ไม่ระบุ -</option> ';
$result = mysql_query($sql) or die("Query line " . __LINE__ . " Error<hr>".mysql_error());
while($rs = mysql_fetch_assoc($result)){
if($xdef == $rs[staffid]){ $selected = "selected class=\"normal_blue\""; } else { $selected = ""; }
echo "<option value=\"$rs[staffid]\" $selected>".$rs['staffname']." ".$rs['staffsurname']." (".$rs['title'] .")</option>";
}
echo"</select>";
mysql_free_result($result);
?>