[SOLVED] Is this efficient?

[evilsanta]

Hi! I have a forum right now, and I am currently writing a PHP script that lists the last 5 posts on my index page...

 

Right now I have the following query

$query="SELECT * FROM phpbb_posts ORDER BY post_id DESC";

 

Then in my

while($row = mysql_fetch_array($result)

 

I have a counter, 1 is added to the counter each loop and when it reaches 5 I call a break. But this seems like it might cause some problems when there are a large amount of posts... is this the right method? Or is there something I should be adding in the query to limit it to give me 5?

[teng84]

$query="SELECT * FROM phpbb_posts ORDER BY post_id DESC limit 5";

[suttercain]

Try this:

 

$query = mysql_query ("SELECT * FROM phpbb_posts ORDER BY post_id DESC LIMIT 0, 5");

 

 

 

[evilsanta]

Ahh, thanks everyone!