Sorting my guestbook posts on time/date (php/mySQL) ← (PHP, MySQL)

I need the posts on my guestbook to be sorted by time ascending. I have been told that I need to add:

ORDER by datetime 

in my code. But I dont know what the correct way to enter this line is. Here is my code:

<?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



Solution:

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

Also you have mysql_close and your other functions are mysqli

Source