include("db_conn.php"); include("db_func.php"); $SQLStr = "SELECT member.*,member_info.*,level.* FROM member AS member "; $SQLStr .= "LEFT JOIN member_info AS member_info ON member.m_id = member_info.m_id "; $SQLStr .= "LEFT JOIN level AS level ON member.m_level = level.m_level WHERE is_licenced = '$lic' AND is_deleted='$del'"; $res = db_query($SQLStr); $nums = db_num_rows($res); ?>
0) { for ($i=0;$i<$nums;$i++) { $row = db_fetch_array($res); if ($i%2 == 0) echo""; else echo""; echo "\n"; echo "\n"; echo ""; echo ""; } echo ""; } ?>
查詢特定會員:
全選
帳號姓名
權限等級
權限變動
" . $row['m_username'] . "(" . $row['m_surname'] . $row['m_frontname'] . ")
"; echo ""; } if ($lic==1&$del==1) { echo ""; echo ""; } if ($lic==0) { echo ""; echo ""; } ?>