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'])){ $searchItem = mysql_escape_string($_POST['searchItem']); $getMatrixData = mysql_query("SELECT * FROM `prf_items` WHERE `deleted` = 0 AND `item_description` LIKE '%$searchItem%' 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(); ?>