我有這張表，它顯示來自 mysql 的數據并通過大多數點擊對它們進行排序，但我沒有 #1 或 #2 等等....這里是代碼：<table align="center" style="width:50%"> <tr> <th>User</th> <th>clicks</th> </tr> <tr> <td> <?php include 'conn.php'; $sql = "select user, count(*) duplicates from users group by user order by duplicates desc"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo $row["user"]. "<br>"; } } else { } ?> </td> <td> <?php include 'conn.php'; $sql = "select user, count(*) AS duplicates from users group by user order by duplicates desc"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo $row["duplicates"]. "<br>"; } } else { } $conn->close(); ?></td> </tr></table>輸出在表格中是這樣的：users clicksuser1 3user2 2user3 1但我希望輸出為：rank users clicks1 user1 32 user2 23 user3 1
2 回答
POPMUISE
TA貢獻1765條經驗 獲得超5個贊
將排名部分添加到表中
<tr>
<th>Rank</th>
<th>User</th>
<th>clicks</th>
</tr>
為每個結果添加排名
<td>
<?php include 'conn.php';
$sql = "select user, count(*) duplicates from users group by user order by duplicates desc";
$result = $conn->query($sql);
$rank = 1;
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $rank. "<br>";
$rank++;
}
}
?>
</td>
完整代碼
<table align="center" style="width:50%">
<tr>
<th>Rank</th>
<th>User</th>
<th>clicks</th>
</tr>
<tr>
<td>
<?php include 'conn.php';
$sql = "select user, count(*) duplicates from users group by user order by duplicates desc";
$result = $conn->query($sql);
$rank = 1;
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $rank. "<br>";
$rank++;
}
}
?>
</td>
<td>
<?php include 'conn.php';
$sql = "select user, count(*) duplicates from users group by user order by duplicates desc";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["user"]. "<br>";
}
}
?>
</td>
<td>
<?php
include 'conn.php';
$sql = "select user, count(*) AS duplicates from users group by user order by duplicates desc";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["duplicates"]. "<br>";
}
}
$conn->close();
?></td>
</tr>
</table>
手掌心
TA貢獻1942條經驗 獲得超3個贊
使用 javascript：
<script type="text/javascript">
var nb = document.getElementsByClassName("number");
for (var i = 0; i < nb.length; i++) {
nb[i].innerHTML = (i+1)+".";
}
</script>
<table align="center" style="width:50%">
<tr>
<th>User</th>
<th>clicks</th>
</tr>
<tr>
<td class="number">
<?php include 'conn.php';
$sql = "select user, count(*) duplicates from users group by user order by
duplicates desc";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["user"]. "<br>";
}
} else {
}
?>
</td>
<td>
<?php
include 'conn.php';
$sql = "select user, count(*) AS duplicates from users group by user order by
duplicates desc";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo $row["duplicates"]. "<br>";
}
} else {
}
$conn->close();
?></td>
</tr>
</table>
- 2 回答
- 0 關注
- 113 瀏覽
添加回答
舉報
0/150
提交
取消