='$date' AND INSVCSTATUS ='NO' GROUP BY NTIHCNO ORDER BY TIMESTAMP DESC"); //while($res = mysql_fetch_array($result)) { // mysql_fetch_array is deprecated, we need to use mysqli_fetch_array while($res = mysqli_fetch_array($result)) { $dts = $res['RID']."***".$res['NTIHCNO']."***".$res['SERVICETYPE']."***".$res['VISTTYPE']; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ''; } ?>

DATE TIME	NTIHC NO.	CLIENT NAME	VIST TYPE	DATA TYPE	SERVICE TYPE	USER INITIAL	ACTION
DATE TIME	NTIHC NO.	CLIENT NAME	VIST TYPE	DATA TYPE	SERVICE TYPE	USER INITIAL	ACTION
".$res['TIMESTAMP']."	".$res['NTIHCNO']."	".$res['CLIENTNAME']."	".$res['VISTTYPE']."	".$res['DATATYPE']."	".$res['SERVICETYPE']."	".$res['USERINITIAL']."	POST CLIENT