php - 按时间/日期对我的留言簿帖子进行排序 (php/mySQL)

Question

我需要将留言簿上的帖子按时间升序排序。我被告知我需要添加:

ORDER by datetime 

在我的代码中。但我不知道输入这一行的正确方法是什么。这是我的代码:

<?php

    $host = "ZZZ"; // Host name 
    $username = "ZZZ"; // Mysql username 
    $password = "ZZZ"; // Mysql password 
    $db_name = "ZZZ"; // Database name 
    $tbl_name = "ZZZ"; // Table name 

    // Create connection
    $conn = mysqli_connect($host, $username, $password, $db_name);
    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }

   $sql = "SELECT * FROM ". $tbl_name ." ";
    $result = mysqli_query($conn, $sql);

    if (mysqli_num_rows($result) > 0) {
        // output data of each row
        while($row = mysqli_fetch_assoc($result)) {
            echo "
        <b>    Name: ". $row["name"]."<br>
            Date Added: : ". date('d-m-Y H:i', $row["datetime"]) ."</b><br><br>
            Comment: ". $row["comment"]."<br>
            <br> 
            ";
        }
    } else {
        echo "0 results";
    }



    mysql_close(); //close database
    ?>

Answer 1

$sql = "SELECT * FROM " . $tbl_name . " ORDER BY datetime ASC";

你还有mysql_close，你的其他函数是mysqli