format("Y-m-d"); $toTime =date('H:i:s'); $dateTime = $myDate . " ".$toTime; if(isset($_POST['done'])){ $clearanceID = mysql_escape_string($_POST['clearanceID']); $SelUserName = mysql_escape_string($_POST['SelUserName']); $SelEMPID = mysql_escape_string($_POST['SelEMPID']); $SelDateCreated = mysql_escape_string($_POST['SelDateCreated']); $SelPosition = mysql_escape_string($_POST['SelPosition']); $getNotes=mysql_query("SELECT * FROM `cl_final_pay_comments` WHERE `cl_id`='$clearanceID' ORDER BY `f_id` ASC"); while($row=mysql_fetch_array($getNotes)){ if($colorb ==='white'){ $colorb=' #f6fed5 '; }else{ $colorb='white'; } $senderID = $row['cl_comment_from']; $senderName = mysql_result(mysql_query("SELECT `u_fname` FROM `vts_users` WHERE `u_id`='$senderID'"),0); echo "
".$row['cl_comments']."
Date: ".$row['cl_comment_date']." By: ".$senderName."
"; } exit(); } ?>