format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $myUserID = $user_data['u_id']; //$myDeptID = $user_data['dept_id']; if(isset($_POST['done'])){ $itemID = mysql_escape_string($_POST['itemID']); $getExecomList = mysql_query("SELECT * FROM `prf_execomcanvassapproval` WHERE `item_code`='$itemID' ORDER BY `id` ASC"); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($getExecomList)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } ?>

Date/Time	EXECOM	Approved Vendor	QTY	Ammount
".$row['date_approved'] ." | ".$row['time_approved']."	"; $exID = $row['approved_by_execom']; $exFName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$exID'"),0); $exLName = mysql_result(mysql_query("SELECT `u_lname` FROM `vts_users` WHERE `u_id`='$exID'"),0); echo strtoupper($exLName). ", ".strtoupper($exFName); echo "	"; $exVendorID =$row['vendor_id']; $getVenName = mysql_result(mysql_query("SELECT `sup_name` FROM `prf_suppliers` WHERE `id`='$exVendorID'"),0); echo strtoupper($getVenName); echo "	".$row['canvass_qty']."	".$row['approved_amount']."