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'])){ $selBuyerID = mysql_escape_string($_POST['selBuyerID']); mysql_query("UPDATE `vts_users` SET `buyer` = '0' WHERE `u_id` = '$selBuyerID'"); } echo ""; $getExecomList = mysql_query("SELECT * FROM `vts_users` WHERE `buyer`=1 ORDER BY `u_lname` ASC"); while($row=mysql_fetch_array($getExecomList)){ $companyName=mysql_result(mysql_query("SELECT comp_name FROM vts_company WHERE comp_id='".$row['company']."'"),0); ?> ".$row['u_id'].""; echo ""; } echo "

".strtoupper($row['u_lname']).", ".strtoupper($row['u_fname'])."

".strtoupper($companyName)."

"; exit(); ?>