if($_POST['Year']==""){
$ResultMAXYear = mysql_fetch_array(mysql_query("SELECT MAX(Year) AS MAX FROM ".$dbcommand.".tb_rmuti_commands"));
$YearSelect = $ResultMAXYear['MAX'];
}else{
$YearSelect = $_POST['Year'];
}
$ResultLogin = mysql_fetch_array(mysql_query("SELECT * FROM ".$dbpersonnel.".personnel WHERE ID = '".$_SESSION['Login']."'"));
$Resultfix_prefix = mysql_fetch_array(mysql_query("SELECT * FROM ".$dbpersonnel.".fix_prefix WHERE ID = '".$ResultLogin['Prefix_ID']."'"));
?>
ผู้เข้าใช้งาน :
เลขที่
ลงวันที่
เรื่อง
if($_POST['Year']==""){
$ResultMAXYear = mysql_fetch_array(mysql_query("SELECT MAX(Year) AS MAX FROM ".$dbcommand.".tb_rmuti_commands"));
$YearP = "AND Year = ".$ResultMAXYear['MAX'];
}else{
$YearP = "AND Year = ".$_POST['Year'];
}
$QueryCommands = mysql_query("SELECT * FROM ".$dbcommand.".tb_rmuti_commands WHERE 1 ".$YearP." ORDER BY Date ASC");
while($ResultCommands = mysql_fetch_array($QueryCommands)){
?>