reverse mysql database results with php

Question

I have am grabbing a whole lot of data from a table in a mysql database and displaying it on a page. The code looks like this.

<?php
$sql = "SELECT * FROM $table_name";
$result = mysql_query($sql);
while($rows = mysql_fetch_array($result)){
?>
<tr class="contact-content">
    <td><?php echo $rows['ID']; ?></td>
    <td><?php echo $rows['name']; ?></td>
    <td><?php echo $rows['email']; ?></td>
    <td><?php echo $rows['tel_home']; ?></td>
    <td><?php echo $rows['tel_mobile']; ?></td>
    <td><?php echo $rows['tel_work']; ?></td>
</tr>
<?php
}
?>

It currently displays results like this

1 | James | [email protected] | 1234567 | 1234567 | 9876

2 | Anna | [email protected] | 8768765 | 6543 | 9876

But I would like to reverse it and display the results something like this ordered by there id

2 | Anna | [email protected] | 8768765 | 6543 | 9876

1 | James | [email protected] | 1234567 | 1234567 | 9876

gronke · Accepted Answer · 2012-07-22 01:59:16Z

7

SELECT * FROM $table_name ORDER BY ID DESC

answered Jul 22, 2012 at 1:59

gronke

1893 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jocelyn · Accepted Answer · 2012-07-22 02:17:20Z

3

Use one of theses queries:

Order by ascending name:

$sql = "SELECT * FROM $table_name ORDER BY name ASC";

Order by descending ID:

$sql = "SELECT * FROM $table_name ORDER BY ID DESC";

edited Jul 22, 2012 at 2:17

answered Jul 22, 2012 at 1:59

Jocelyn

11.4k11 gold badges47 silver badges63 bronze badges

Comments

Mike Mackintosh · Accepted Answer · 2012-07-22 02:29:23Z

2

Take a look at the ORDER BY clause.

You are looking for a DESCENDING order:

$sql = "SELECT * FROM $table_name ORDER BY ID DESC";

answered Jul 22, 2012 at 2:29

Mike Mackintosh

14.3k7 gold badges64 silver badges87 bronze badges

Collectives™ on Stack Overflow

reverse mysql database results with php

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related