1 回答

TA贡献1816条经验 获得超4个赞
你这里有一个功能,你不能$dbc在本地使用。将此变量传递给函数:
retrieve_column($par, $dbc);
查询有一个小错误。$parent变量需要单引号:
SELECT item FROM category WHERE parent = '$parent' ORDER BY item ASC
对于循环,一个while ($row = mysqli_fetch_assoc($r))就够了
<?php
include ('connect.php');
include ('head.html');
echo '<div class="categ"><p class="b">Health</p>';
function retrieve_column($parent, $dbc){
$sql = "SELECT item FROM category WHERE parent = '$parent' ORDER BY item ASC";
$r = mysqli_query($dbc, $sql);
if (!$r) {
echo "Couldn’t make a connection to DB.";
} else {
while ($row = mysqli_fetch_assoc($r)) {
echo '<a class="text" href="">' . $row['item'] . '</a><br />';
}
}
}
$par = 1;
retrieve_column($par, $dbc);
mysqli_free_r($r);
mysqli_close($dbc);
?>
- 1 回答
- 0 关注
- 116 浏览
添加回答
举报