How to display table content in reverse order?

Question

I need to display table of contents from bottom to top. Since when a new row is inserted, it appears at bottom and when I access it using mysqli_fetch_array it shows the most recent inserted row at the bottom. The code is like this:

<?php
    $abc = mysqli_connect("localhost","root","","members") or die(mysqli_error($abc));
    $select_query = "SELECT title, url, photographer, genere, timestamp FROM gallery";
    $select_query_result = mysqli_query($abc, $select_query) or die(mysqli_error($abc));
?>

And somewhere in html, this code appears.

<ol class="pictures">
    <?php while($row = mysqli_fetch_array($select_query_result)) { ?>
        <li class="thumbnail" data-div="<?php echo $row['genere'] ?>,<?php echo $row['photographer'] ?>,<?php echo $row['title'] ?>,<?php echo $row['timestamp'] ?>" style="background-image: url(<?php echo $row['url'] ?>)">
        </li>
    <?php } ?>
</ol>

So, what should I do to display it in reverse order so that I can get the most recent entry on top while displaying.

Order query results by some field, `timestamp` I suppose, or maybe `id`, if you have `id` field. — u_mulder, Sep 27 '17 at 13:03
Possible duplicate of [How to display table data in reverse? (php)](https://stackoverflow.com/questions/14976848/how-to-display-table-data-in-reverse-php) — CodeCaster, Sep 27 '17 at 13:18
Read [ask], do some research first. Your question's title is literally answered by the first Google hit. — CodeCaster, Sep 27 '17 at 13:18

score 2 · Answer 1 · answered Sep 27 '17 at 13:05

Simply order your SQL Query by using either

ORDER BY attribute ASC/DESC

So for example if you want the most recent entry on top, simply change your SQL query to:

"SELECT title, url, photographer, genere, timestamp FROM gallery ORDER BY timestamp desc"

And it should work. You can do this with any attribute you want. I recommend to do it with the primary key (ID) if you have one, but since you're not selecting it, you can do it with your timestamp too. https://www.tutorialspoint.com/sql/sql-sorting-results.htm

score 0 · Answer 2 · edited Sep 27 '17 at 13:13

0

Use Order By:

<?php
        $abc = mysqli_connect("localhost","root","","members") or die(mysqli_error($abc));
        $select_query = "SELECT title, url, photographer, genere, timestamp FROM gallery ORDER BY timestamp DESC";
        $select_query_result = mysqli_query($abc, $select_query) or die(mysqli_error($abc));
        ?>

edited Sep 27 '17 at 13:13

Funk Forty Niner

74,450
15
68
141

answered Sep 27 '17 at 13:05

Adaleni

966
7
15

score 0 · Answer 3 · answered Sep 27 '17 at 13:09

0

Just Modify Your SQL Query

Use ORDER BY

SELECT title, url, photographer, genere, timestamp FROM gallery ORDER BY id DESC ;

answered Sep 27 '17 at 13:09

Aman Kumar

4,533
3
18
40

score 0 · Answer 4 · answered Sep 27 '17 at 13:12

0

If you doesn't want to use ORDER BY:

for($i = count($select_query_result), $i > 0; $i--) {
    // Actions
}

answered Sep 27 '17 at 13:12

Nathanael Demacon

1,169
7
19

How to display table content in reverse order?

4 Answers4