SQL SELECT Error


SQL SELECT Error

这个select语句有什么问题?我收到以下错误:警告:mysqli_num_rows()要求参数1为mysqli_result,给定布尔值。我什么都试过了,但都想不通。非常感谢您的帮助!

            $sql = "SELECT gm.gname, gp.logo
        FROM gmembers AS gm
        LEFT JOIN groups AS gp ON gp.name = gm.gname
        WHRER gm.mname ='$log_username'";
$query = mysqli_query($db_conx, $sql);
$g_check = mysqli_num_rows($query);

您有一个打字错误

SELECT gm.gname, gp.logo
FROM gmembers AS gm
LEFT JOIN groups AS gp ON gp.name = gm.gname
WHERE gm.mname ='$log_username'

请尝试在phpmyadmin/用于DB的任何GUI中运行此程序。