Jump to content

Select Statement


daebat

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/192659-select-statement/#findComment-1014971
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.