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 關注
- 134 瀏覽
添加回答
舉報