如何从下往上加载数据库图像/文本？ （最新帖子第一）

Question

I have code in which a user can upload a file/image and text, and then it displays onto the page. I would like for the newest uploaded posts to show first and oldest last, so basically from the bottom up. Here is my code where I am loading it normally:

PHP/SQL:

<?php
$db = mysqli_connect("localhost", "", "", "boxofmem_GMSConnect");
$sql = "SELECT * FROM images";
$result = mysqli_query($db, $sql);
while ($row = mysqli_fetch_array($result)) {
    echo "<div id='img_div'>";
    echo "<p style='font-family:Roboto;color:white;font-size:20px;'>".$row['text']."</p>";
    echo "<img src='images/".$row['image']."' ' style='width:100%;height:100%;'>";
    echo "</div>";
}

?>

FIELDS:

ID (int:11) IMAGE (BLOB) TEXT (TEXT)

Answer 1

If you mean the reverse order, that’s done in SQL:

SELECT * FROM images ORDER BY something DESC

where something is the actual field you want to sort. It may be the primary key or a date.

In your case, the ID column appears to be the primary key, and is probably auto-incremented. That means recent records have higher values. To display the most recent first:

SELECT * FROM images ORDER BY ID DESC

the ORDER BY clause, which is optional, but always the last clause of an SQL statement, determines the sort order. The default order is ascending ASC, and is implied if you don’t specify a direction.

DESC reverses the order. This will bring the most recent to the top.