我有以下php代码:
$seasons = array("Autumn", "Winter", "Spring", "Summer");
现在我还有一个数据库,里面有一个季节表,里面的季节像:
+--------+
| Season |
+--------+
| Autumn |
| Winter |
| Spring |
| Summer |
+--------+
所以我想从我的数据库中获取季节,并将它们放在这个数组中,但如何做到这一点。自身尝试失败(使用while
、mysql_fetch_array
、mysql_fetch_ASSOC
等尝试)
这是为初学者准备的:
$result = mysql_query("SELECT Season FROM Seasons ORDER BY Season");
这应该会给我所有的季节,但我被困在这里。搜索了互联网,但那里的例子太复杂了,我不需要。。。
非常感谢
$seasons = array();
$result = mysql_query("SELECT Season FROM Seasons ORDER BY Season");
while($row = mysql_fetch_num($result))
$seasons[] = row[0];
试试这段代码。它将用查询结果填充一个名为$seasons的数组。
$result = mysql_query("SELECT Season FROM Seasons ORDER BY Season");
while($row = mysql_fetch_array($result)){
$season=$row['Season'];
$seasons[] = $season;
}
它似乎对我有效。
while ($row = mysql_fetch_assoc($result)) {
echo $row['Season'] . "n";
}
这将在结果中一次循环一行。当没有剩余行时,mysql_fetch_assoc
返回false
,并退出循环。