Pagination w/ MySQL Print Backwards

[itsureboy]

Im running pagination and i want to know how to display rows in my MySQL table backwards so the last inserted row can be showed on the 1st page. Thanks...

[Millar]

In the Query add 'ORDER BY `id` DESC' ( without the quotes ) change 'id' to whatever your auto_increment primary key is.

[itsureboy]

How would i go about adding it to the code below I tried but it did not work.Thanks....<br>

[code]
<?php

// Database Connection
include 'db.php';

// If current page number, use it
// if not, set one!

if(!isset($_GET['page'])){
    $page = 1;
} else {
    $page = $_GET['page'];
}

// Define the number of results per page
$max_results = 2;

// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);

// Perform MySQL query on only the current page number's results

$sql = mysql_query("SELECT * FROM pages LIMIT $from, $max_results");

while($row = mysql_fetch_array($sql)){
    // Build your formatted results here.
    echo $row['title'];
}

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM pages"),0);

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);

echo "<tr>";
echo stripslashes("<td class=\"leftnavi2\" colspan=\"1\"> ");
echo "</td>";
echo stripslashes("<td class=\"titlesection2\" colspan=\"4\"> ");

// Build Page Number Hyperlinks


// Build Previous Link
if($page > 1){
    $prev = ($page - 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$prev\"><<Previous</a> ";
}

for($i = 1; $i <= $total_pages; $i++){
    if(($page) == $i){
        echo "$i ";
        } else {
            echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";
    }
}

// Build Next Link
if($page < $total_pages){
    $next = ($page + 1);
    echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>";
}
echo "</center>";
echo "</td>";
echo "</tr>";
?>
[/code]

[itsureboy]

Any Help?