[SOLVED] MYSQL ORDER BY

[Northern Flame]

hello,

I am trying to order my data by the id,

but i only want to show the latest 5 that

were entered. I know how to only display

5, but it shows the first 5, not the last 5,

can anyone help?

 

        $limit = 5;
$query = "SELECT * FROM table ORDER BY id LIMIT $limit";
$result = mysql_query($query) or die("ERROR " . mysql_error());

[lightningstrike]

$limit = 5;
$query = "SELECT * FROM table ORDER BY id DESC LIMIT $limit";
$result = mysql_query($query) or die("ERROR " . mysql_error());

 

That should work.

[Northern Flame]

alright thanks