displaying limited data

[Myrkul]

alright I was wondering how i could display the most 5 most recent rows in my database..

the begining of my loop to display is

$result = mysql_query($query) OR die("result");

while($row = mysql_fetch_array($result)) { 

how do I modify that so it only displays the 5 most recent rows in the dbase?

[cgraz]

the easiest way to do it is to LIMIT the actual query so it only returns the 5 most-recent.

SELECT * FROM table ORDER BY id DESC LIMIT 5;

Cgraz