'2021-12-31' and em.femplcode='$empl_id' and wk.femplcode is null group by left(fattndate,7) desc;"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 0) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i = 1; while ($myrow = mysqli_fetch_assoc($myres)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i++; } echo "
#Empl NameMonthPending
$i. $myrow[femplname] $myrow[fattnmnth] $myrow[fworkpend]
"; } else { echo "
No work entry pending!
"; } $mysql = "select fworkcode,date_format(fworkdate,'%d/%m/%Y') as fworkdate,fworkname,fworkdetl,fviewdetl from workentry where femplcode='$empl_id' and ifnull(fviewdetl,'')<>'' and facknnote='F' and ifnull(fdelestat,'F')='F' order by fworkcode desc limit 15"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 0) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i = 1; while ($myrow = mysqli_fetch_assoc($myres)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i++; } echo "
#DateEmpl NameAction
$i. $myrow[fworkdate] Work Name: $myrow[fworkname]
Work Details: $myrow[fworkdetl]
Review Remarks: $myrow[fviewdetl]		 Acknowledge
"; } else { echo "
No review notices!
"; } ?>