WordPress.org

1. opblog
   Member
   Posted 1 year ago #

   hey guys.. here is what i am trying to say today is Aug 08, 2010..so what will show is

   Aug 08, 2010
   Post title 1
   Post title 2
   and so on for the other post for this date

   Aug 08, 2010
   Post title 1
   Post title 2
   and so on for the other post for this date

   but i also want to show this only 3 time. so it will show all the post grouped by dates for last 3 days.

   thank you

2. alchymyth
   The Sweeper
   Posted 1 year ago #

   time parameter of query_posts:
   http://codex.wordpress.org/Function_Reference/query_posts#Time_Parametershttp://codex.wordpress.org/Function_Reference/query_posts#Time_Parameters

   the_date
   http://codex.wordpress.org/Function_Reference/the_date

3. opblog
   Member
   Posted 1 year ago #

   hey thanks i got this but stuck on one thing i want to put category name with the post that showing here.. how can i do that...
   

   <?php
     global $wpdb;
     $splitformat = '%A %B %Y';
     $sql = "SELECT ID, post_title, post_date
   			FROM $wpdb->posts
   			WHERE post_type = 'post' AND post_status = 'publish' AND post_date > '" . date('Y-m-d', strtotime('-3 days')) . "'
   			ORDER BY post_date DESC
   			";
   
     $posts = $wpdb->get_results($sql);
     $archives = array();
     foreach($posts as $post)
   	{
   		$key = strftime($splitformat, strtotime($post->post_date));
   		$archives[$key][] = $post;
   	}
     $output = $pre_HTML;
     	foreach($archives as $heading => $posts)
   	{
   		echo '<' . $headingtag . '>' . htmlentities($heading) . '</' . $headingtag . '>', "\n";
   		echo '<ul>', "\n";
   
   		foreach($posts as $post)
   		{
   			echo '	<li><a href="' . get_permalink($post->ID) . '">' . $post->post_title . '</a></li>', "\n";
   		}
   
   		echo '</ul>', "\n\n";
   	}
   ?>

   thanks

4. rezaurc
   Member
   Posted 1 year ago #

   Hello opblog, the above code helped me a lot, buy i want each date to be categories with post tittle as u. Pls help anyone?

5. rezaurc
   Member
   Posted 1 year ago #

   here we go........
   <?php
   global $wpdb;
   $splitformat = ' %A %d %B %Y';
   $sql = "SELECT ID, post_title, post_date
   FROM $wpdb->posts
   WHERE post_type = 'post' AND post_status = 'publish' AND post_date > '" . date('Y-m-d', strtotime('-3000 days')) . "'
   ORDER BY post_date DESC
   ";
   $posts = $wpdb->get_results($sql);
   $archives = array();
   foreach($posts as $post)
   {
   $key = strftime($splitformat, strtotime($post->post_date));
   $archives[$key][] = $post;
   }
   $output = $pre_HTML;
   foreach($posts as $post) :
   $category = get_the_category();
   $cats[$category[0]->cat_ID] = $category[0]->cat_name;
   endforeach;
   $cats = array_flip($cats);

   foreach($archives as $heading => $posts)
   {
   echo '<' . $headingtag . '>' . htmlentities($heading) . '</' . $headingtag . '>', "\n";
   echo '

   ', "\n";
   foreach($cats as $current_cat){?>
   <h4 id="cat-<?php echo $current_cat; ?>">" title="View all posts in <?php echo get_the_category_by_id($current_cat); ?>"><?php echo get_the_category_by_id($current_cat); ?></h4>
   <?php foreach($posts as $post)
   $category = get_the_category();
   if($current_cat == $category[0]->cat_ID) // if post is in correct category
   {
   echo '
   • ID) . '">' . $post->post_title . '
   ', "\n";
   }
   }
   echo '

   ', "\n\n";
   }
   ?>

Topic Closed

This topic has been closed to new replies.