Looping through a database table a limited number of times.

[fez]

Hello,

 

I'm new! I am trying to populate a list of locations based on ratings. I can populate the list just fine but it's displaying every record in the table. Is there a way of only looping 4 times so as to just display the top 4 records?

 

Here's the code:

 

$result = mysql_query("SELECT * FROM locations ORDER BY rating DESC");

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

  echo $row['name'];
  echo "<br>;
  
  }

 

Thankyou in advance for any help 

[JKG]

SELECT * FROM locations ORDER BY rating DESC LIMIT 0, 4

[fez]

Excellent, thank you