format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $activeID=$user_data['u_id']; if(isset($_POST['done'])){ $itemClassID = mysql_escape_string($_POST['itemClassID']); $itemTypeID = mysql_escape_string($_POST['itemTypeID']); $itemTypeName = mysql_escape_string($_POST['itemTypeName']); if($itemTypeName ==""){ //Expense ID Only $getMatrixData = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `asset_cat`='$itemClassID' ORDER BY `item_description` ASC"); }else{ $getMatrixData = mysql_query("SELECT * FROM `prf_items` WHERE `deleted`=0 AND `asset_cat`='$itemClassID' AND `item_class`='$itemTypeName' ORDER BY `item_description` ASC"); } echo ""; while($row=mysql_fetch_array($getMatrixData)){ ?>".strtoupper($row['id']).""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

"; $expID = $row['expense_id']; $expName = mysql_result(mysql_query("SELECT `description` FROM `prf_expensecategory` WHERE `id`='$expID'"),0); echo strtoupper($expName); echo "

"; $expCat = $row['asset_cat']; $expCatName = mysql_result(mysql_query("SELECT `description` FROM `prf_expenseitems` WHERE `id`='$expCat'"),0); echo strtoupper($expCatName); echo "

"; echo $row['item_class']; echo "

".strtoupper($row['item_description'])."

".strtoupper($row['uom'])."

"; } exit(); ?>