| '2020-11-30' order by freptname"; } else { $mysql = "select distinct wk.freptempl,e2.femplname as freptname from workentry wk left join maswork_type wt on wk.fworktype = wt.fworktype left join masempl em on wk.femplcode = em.femplcode and em.frepthead = '$empl_id' left join masempl e2 on wk.freptempl = e2.femplcode where ifnull(wk.fdelestat,'F')='F' and wk.fworkdate>'2020-11-30' order by freptname"; } $myres = mysqli_query($mycon, $mysql); echo ""; ?> | '' order by femplname"; } else { $mysql = "select distinct femplname,wk.femplcode,em.fdeptcode from workentry wk inner join masempl em on wk.femplcode = em.femplcode and em.frepthead = '$empl_id' and em.femplstat='T' where ifnull(wk.femplcode,'')<>'' order by femplname"; } $myres = mysqli_query($mycon, $mysql); echo ""; ?> | "; if (mysqli_num_rows($myres) > 1) { echo ""; } while ($myrow = mysqli_fetch_assoc($myres)) { echo ""; } echo ""; ?> |