php - MySQL 查询返回数千个空结果

Question

当我运行第二个查询来选择部门时，它返回我的部门列表，大约有 20 条记录，然后返回数千个空白条目，页面在浏览器中卡住，我做错了什么？

        mysql_select_db("ita", $con);

        $results = mysql_query("SELECT * FROM `Colleges`");

        $colleges = array();

        while($row = mysql_fetch_assoc($results))
            {
                $colleges[] = array("Name" => $row['Name'], "Value" => $row['Value'], "ID" => $row['CollegeID']);
            }

        $collegecount = count($colleges);

        $depts = array();

        $result1 = mysql_query("SELECT * FROM `Departments` WHERE uid = `$uid`");
        while($row = mysql_fetch_assoc($result1))
        {
            $depts = array("Name" => $row['Name'], "Value" => $row['Value'], "ID" => $row['CollegeID']);
        }

        $result = mysql_query("SELECT * FROM `users` WHERE wmuid = '$uid'");
        while($row = mysql_fetch_assoc($result)){

        //POPULATE FORM FIELDS FROM DB

Answer 1

您的 $uid 周围有反引号。我不确定这到底会做什么，因为我怀疑你有一个与 $uid 中的名称相同的列，但它可能会导致一些奇怪的未定义行为。将 ` 更改为 ' 就像:

SELECT * FROM `Departments` WHERE `uid` = '$uid'

编辑

或者，如果uid列存储数字类型，则完全删除引号，例如:

SELECT * FROM `Departments` WHERE `uid` = $uid