"; if ($type_id == 'ADMIN') { $mysql = "select * from masdept where fdeptstat='T' and fdeleted<>'T' order by fdeptname"; } elseif ($type_id == 'CHIEF') { $mysql = "select * from masdept dp inner join masdept_user du on dp.fdeptcode = du.fdeptcode and du.fusercode='$user_id' where fdeptstat='T' and fdeleted<>'T' order by fdeptname"; } else { $mysql = "select * from masdept dp inner join masdept_user du on dp.fdeptcode = du.fdeptcode and du.fusercode='$user_id' where fdeptstat='T' and fdeleted<>'T' order by fdeptname"; } $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 1) { echo "--SELECT--"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "$myrow[fdeptname]"; } echo ""; ?>

"; $mysql = "select * from documents_type where ifnull(fdeleted,'F')<>'T' order by ftypeordr, fdocstype"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 1) { echo "--SELECT--"; } while ($myrow = mysqli_fetch_assoc($myres)) { echo "$myrow[fdocstype]"; } echo ""; ?>

"; $mysql = "select * from sys_user_type order by fuserordr"; $myres = mysqli_query($mycon, $mysql); if (mysqli_num_rows($myres) > 1) { echo "ALL USERS"; } while ($row = mysqli_fetch_assoc($myres)) { echo "$row[ftypedesc]"; } echo ""; ?>