[SOLVED] php mysql select

[dezkit]

how do i select the 5 latest mysql fields, i got ID int

 

example code:

<?php
// Make a MySQL Connection
$query = "SELECT * FROM example"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
echo $row['name']. " - ". $row['age'];
echo "<br />";
}
?>

[Bauer418]

Well assuming your ID field is an auto_increment, you should just be able to run this query:

 

SELECT * FROM example ORDER BY id DESC LIMIT 5

 

Which will grab the 5 most recent items in the database, assuming that is what you want.

[dezkit]

thanks, +bookmarked