我运行这个查询
$result1 = mysql_query("SELECT * FROM 'departments'");
while($row1 = mysql_fetch_assoc($result1))
{
$depts = array("Name" => $row1['Name'], "Value" => $row1['Value'], "ID" => $row['CollegeID']);
}
和其他三个简单查询,一个将数据加载到配置文件文本框中,另一个加载下拉列表。我的查询在这里或我的PHP代码,可能会导致这是错误的。它只返回大约51条记录。你认为它可能是MySQL服务器运行在2008 Windows server上的服务器吗?
也许您的departments表中有很多列。试试这个:
$result1 = mysql_query("SELECT Name, Value, CollegeID FROM 'departments'");
while($row1 = mysql_fetch_assoc($result1))
{
$depts = array("Name" => $row1['Name'], "Value" => $row1['Value'], "ID" => $row['CollegeID']);
}
您也可以尝试使用OOP mysqli函数而不是旧版本的mysql。
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$mysqli->query("SELECT Name, Value, CollegeID FROM departments");
永远不要使用*
$result1 = mysql_query("SELECT Name, Value, CollegeID FROM 'departments'");
while($row1 = mysql_fetch_assoc($result1))
{
$depts = array("Name" => $row1['Name'], "Value" => $row1['Value'], "ID" => $row['CollegeID']);
}
并使用LIMIT
$result1 = mysql_query("SELECT Name, Value, CollegeID FROM 'departments' LIMIT 1");
while($row1 = mysql_fetch_assoc($result1))
{
$depts = array("Name" => $row1['Name'], "Value" => $row1['Value'], "ID" => $row['CollegeID']);
}
在你的情况下没关系因为你总是用新的一行
$depts
变量