Display last 10 database entires?

[Anon]

I have a site I'm converting to PHP andMySQL. The problem I have is
this:
I want to display news items (it's a hardware news site)
starting with the newest entries in the database (at the end of the database) and the 5 or 10
behind it. From the top of the page to the bottom. I cannot figure out
how to pull from the end of the database without knowing the numbers
or how to display from top to bottom. Here is the code I'm currently
using to display the first ten:

<?php
$count = 0;
$news=9;
$dt = date("m-d-Y H:i:s (T)");
$db = mysql_connect ("localhost", "username", "password")
or die (errmailer());
mysql_select_db ("my_database", $db);
$result = mysql_query("SELECT * FROM ARTICLES ORDER BY ARTICLEID",$db);

if ($result)
{
$numfields = mysql_num_fields($result);

       while (($row = mysql_fetch_row($result)) && ($count!=$news))

                    {

                    ?>
                    <A HREF="?page=articles#a<? print($row[0]); ?>" class="roll"> <? print(ucwords($row[1]));?><BR><hr width="10%" align="center" noshade color="#666666" size="1"><?
                    $count++;
                    }
                    } else
                    {
                    print ("There Was An Error! Code: '$result'<br>");
                    }
                    ?><A HREF="?page=articles#a<? print($row[0]); ?>" class="roll"><? print(ucwords($row[1]));?><BR><BR><?
                    mysql_close ($db);

?>

Any help? I'm totally lost.

Matt

[sepodati]

<?php
$dt = date("m-d-Y H:i:s (T)");
$db = mysql_connect ("localhost", "username", "password")
or die (errmailer());
mysql_select_db ("my_database", $db);
$result = mysql_query("SELECT * FROM ARTICLES ORDER BY ARTICLEID DESC LIMIT 10",$db);

if ($result)
{
$numfields = mysql_num_fields($result);

while ($row = mysql_fetch_row($result))

{

?>
<A HREF="?page=articles#a<? print($row[0]); ?>" class="roll"> <? print(ucwords($row[1]));?><BR><hr width="10%" align="center" noshade color="#666666" size="1"><?
$count++;
}
} else
{
print ("There Was An Error! Code: '$result'<br>");
}

I'm not sure what you're trying to do with the link, so I don't know if that part will work. But the ORDER BY articleid DESC LIMIT 10 will pull the last 10 news items out of the database...

---John Holmes...

[Anon]

Oh my god I LOVE YOU! That worked EXACTLY the way I wanted!!!!!!!!!!!

[sepodati]

Gee, I hardly know you.. 🙂

Glad it worked...

---John Holmes...

[eagleeyes]

n/t

[Anon]

That works if you can afford to have the result in inverse order. How can I get the last 'x' entries and keep them ordered by date using ASC?