format("Y-m-d"); $prfTime = date('H:i:s'); $myDate = date_create() ->format("Y-m-d"); $prfDateTime=$prfDate. " ".$prfTime; //$myUID = $user_data['u_id']; if(isset($_POST['done'])){ $MyPageCount = mysql_escape_string($_POST['MyPageCount']); $myOffSet = mysql_escape_string($_POST['myOffSet']); $MyRowCount = mysql_escape_string($_POST['MyRowCount']); $CurrentpageCount = mysql_escape_string($_POST['CurrentpageCount']); $recordPerPage = mysql_escape_string($_POST['recordPerPage']); ?> "; echo ""; echo ""; echo ""; //####################################################################################################### //####################################################################################################### $getItemHdr = mysql_query("SELECT * FROM `prf_ff_message` WHERE `deleted`=0 AND `send_to`='$uniqueRefID' || `deleted`=0 AND `sender_id`='$uniqueRefID' ORDER BY id DESC"); while($row=mysql_fetch_array($getItemHdr)){ $senderID = $row['sender_id']; $sendFName=mysql_result(mysql_query("SELECT u_fname from vts_users WHERE u_id= $senderID"),0); $sendLName=mysql_result(mysql_query("SELECT u_lname from vts_users WHERE u_id= $senderID"),0); $prfStatus = $row['read']; if($prfStatus == 1){ $isRead ='Read'; $fontColor='gray'; }else{ $isRead ='Unread'; $fontColor='red'; } $count = $count + 1; ?>".$row['id'].""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; } ?>

".strtoupper($row['ref_code'])."	".strtoupper($row['date'])."	".strtoupper($row['time'])."	".strtoupper($sendLName).", ".strtoupper($sendFName)."	".strtoupper($row['message'])."	"; echo $isRead; echo"	"; if($row['sender_id']==$uniqueRefID){ echo "Sent"; }else{ echo "Received"; } echo"
Selected Record: