我正在尝试获得此输出
Province
1.city 1 33poits
2.city 2 33poits
3.city 3 33poits
我目前的输出是什么
Province
1.city 1 33points
Province
2.city 2 33points
Province
3.city 3 33points
请在这里帮助一个新手,下面是我的 php 代码
<?php
$sql = "SELECT * FROM ccty WHERE ID=".$ID;
$results = $mysqli->query($sql);
if ($results->num_rows > 0) {
while ($row = $results->fetch_object()) {
?>
<table>
<tr><?= $row->PID; ?>
<td><?= $row->SPID; ?><?= $row->points; ?></td>
</tr>
<?php
}
} else {
echo "No record available!";
}
?>