$result = $pdo->prepare("SELECT * FROM chatbox");
$result->execute();
while ($row = $result->fetch(PDO::FETCH_ASSOC))
{
$username = $row['username'];
$message = $row['message'];
echo $username, ' - ', $message, '<br>';
}
?>
基本上,这是我用于聊天框系统的代码,我想制作它,以便显示出最高的十大CHAT_ID结果,并且它会自动不断更新十个最高的结果。
SELECT * FROM chatbox
->
SELECT * FROM chatbox ORDER BY id DESC LIMIT 10