format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $myDeptID = mysql_escape_string($_POST['myDeptID']); $itemClass = mysql_escape_string($_POST['itemClass']); echo ""; //$getItemCategory = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `dept_id`='$myDeptID' AND `item_description`!='' AND `item_class`='$itemClass' GROUP BY item_description ORDER BY item_description ASC "); $getItemCategory = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `item_description`!='' AND `item_class`='$itemClass' GROUP BY item_description ORDER BY item_description ASC "); echo "
"; echo ""; ?>"; while($cRow=mysql_fetch_array($getItemCategory)){ ?>
".strtoupper(TRIM($cRow['item_description'])).""; echo ""; } echo "
"; } ?>