include("db_conn.php"); include("db_func.php"); // 使用 JOIN 語法將 member、member_info 及 level 三個 table 整 // 合為一個 Table BEGIN $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); // 使用 JOIN 語法將 member、member_info 及 level 三個 table 整 // 合為一個 Table END ?>