How can I change the order of the results to display the newest post first in a PHP application?

To display the newest post first in a PHP application, you can achieve this by sorting the results in descending order based on the timestamp of the posts. This can be done by using the ORDER BY clause in your SQL query to sort the results by the timestamp column in descending order. 

// Connect to your database
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to retrieve posts sorted by timestamp in descending order
$sql = "SELECT * FROM posts ORDER BY timestamp DESC";

$result = $conn->query($sql);

// Display the posts
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Title: " . $row["title"]. " - Content: " . $row["content"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

Keywords

PHP sorting order newest post display

Related Questions