How to return the last 10 rows of a database

[Dan Gaffey]

Hello, I'm trying to get A recent searches to echo onto my website, but i don't know how I need to modify my query to get this to work.
here iswhat I have so far:

 <?php
 
 
 
//connect to your database 
mysql_connect("localhost",$user,$pass); //(host, username, password)
 
//specify database 
mysql_select_db($db) or die("Unable to select database"); //select which database we're using
 
 
 
$result = mysql_query("SELECT * FROM RecentSearches ");
 
 
 
 
// begin to show results set
echo "<b><u>Results</b></u> <br/><br/><br/>";
 
 
// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["song_name"];
  $artist = $row["artist"];
  $Buy = $row["purchase_link"];
 
 
 
  echo "$title - " ;
  echo  "$artist - "  ;
  printf('<a href="%s" target="_tab">Buy this track</a>', $Buy);
  echo "<br/><br/>";
 
  }
 
 
?>
 

This just throws every song that's been searched onto the page in a massive list, but I only want the last 10 searched (so the last 10 entries in the table). Any ideas?

[JKing]

What other fields are in your table?

To retrieve ten results you can use the Limit keyword in your sql, and to get the latest 10 you will want to use ORDER BY ideally on a date field.

It would look something like this:

$sql = "SELECT * FROM RecentSearches ORDER BY date_added DESC LIMIT 10";
$results = mysql_query($sql);
 

Replace date_added with your date field if you have one if not the ID should also work.

[Dan Gaffey]

I have the songID so I could just order descending using that because the highest songID is the most recent one, correct?

[Dan Gaffey]

Oh, just read about the ID field, that's what I get for skim reading on the bus. I'll try it out when I'm at a computer. Thankyou :)

[Dan Gaffey]

Works perfectly! Have a list of songs that refreshes the ten most recent now, thanks :)