How to display table data in reverse? (php)

Question

I have simple code for displaying images. I created table with 4 columns (ID, location, capture, equence) and inserted there 18 records. My question is: how to display all records from table in reverse mode? I need to make that the last entry will be displayed first, and the first entry displayed last.

What I need: 18-1 What I have now: 1-18

I was searching for simple codes to do that, but notwing worked at all. So i'd be very grateful if someone will help me to solve that problem.

Heres the basic code of my display script:

<?php

mysql_connect("localhost", "***", "***") or die(mysql_error());
mysql_select_db("martinidb1337") or die(mysql_error());

$result = mysql_query("SELECT * FROM klpgalerija") or die(mysql_error()); while($row = mysql_fetch_array( $result )) {

    echo '<p><img src="'.$row['location'].'"></p>';
}

"SQL tutorial" is likely a relevant search. – Feb 20 '13 at 10:08 — , Feb 20 '13 at 10:08

score 3 · Accepted Answer · edited May 25 '19 at 14:29

3

You have to use MySQL ORDER BY clause for that,

SELECT * FROM klpgalerija ORDER BY id DESC

Note: Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated.

So use either PDO or MySQLi (IMO PDO is way to go)

edited May 25 '19 at 14:29

Zoe

27,060
21
118
148

answered Feb 20 '13 at 09:55

Rikesh

26,156
14
79
87

score 1 · Answer 2 · answered Feb 20 '13 at 09:54

1

Changed query from "SELECT * FROM klpgalerija" to "SELECT * FROM klpgalerija ORDER BY ID DESC"

<?php

mysql_connect("localhost", "***", "***") or die(mysql_error());
mysql_select_db("martinidb1337") or die(mysql_error());

$result = mysql_query("SELECT * FROM klpgalerija ORDER BY ID DESC") or die(mysql_error()); while($row = mysql_fetch_array( $result )) {

    echo '<p><img src="'.$row['location'].'"></p>';
}

answered Feb 20 '13 at 09:54

Prasanth Bendra

31,145
9
53
73

mysql_* functions are deprecated use PDO or mysqli_* – Prasanth Bendra Feb 20 '13 at 09:57
Thats strange. I was trying to do that couple of days ago, and that wont worked at all. Now i paste your code and it worked. Thanks! – user2090528 Feb 20 '13 at 10:03

score 1 · Answer 3 · edited Feb 20 '13 at 09:58

1

add an order by desc clause in your sql query

$result = mysql_query("SELECT klpgalerija.* FROM klpgalerija order by klpgalerija.ID desc") or die(mysql_error());

edited Feb 20 '13 at 09:58

Prasanth Bendra

31,145
9
53
73

answered Feb 20 '13 at 09:55

novalagung

10,905
4
58
82

How to display table data in reverse? (php)

3 Answers3

Linked