Select Statement

[daebat]

I'm trying to pull the latest blog posts from a blog but only the latest 5.  What do I need to modify from this snippet:

 

$data = mysql_query("SELECT post_date, post_title FROM wp_posts ORDER BY post_date ASC") or die(mysql_error());

 

 

[daebat]

I've modified it a little bit so you all can get what I'm trying for:

 

<?php
$data = mysql_query("SELECT post_date, post_title, post_status, post_type FROM wp_posts ORDER BY post_date ASC ") or die(mysql_error());

//Puts it into an array
while($info = mysql_fetch_array( $data ))

if($info['post_status'] == 'publish'){

if($info['post_type'] == 'post'){
   
echo"<li>".$info['post_title'] . "</li>";
}
else{
}
}
else{

}
?>

 

This lists all of the posts but I need only the latest 5.

[daebat]

figured it out... THANKS PHP FREAKS!  YOU"RE SO HELPFUL! 

[shlumph]

Just so people know the answer, you'll want to limit your query:

 

SELECT post_date, post_title FROM wp_posts ORDER BY post_date ASC LIMIT 5