Latest Post from each Category plugin for WordPress

Karl: If you email me directly I might be able to help you do this another way. One way would be to use a plugin I made to display the most recent post from one category only. I could modify my plugin to display all post if it is necissary.

It would help to know what else you are trying to do on the same page. You can click on my name to visit my website and see if its something you are interested.

My email is (stoi2m1) [at] {yahoo} /dot\ .

Jesse

Here are the mods that I have implemented into this plugin.

Andy I think MOD 1 will answer your question.

I have not made these mods accessible from the options menu. There is no need for me to be able to change these option. So look at the Origional Code and then my Current Code then determine whats going on to make your own changes.

Heres a link to http://www.stormscorner.com/ewb the lower section of the homepage is being produced by the latest_post_from _category plugin.

**MOD 1. This keeps a certain category from listing**

-In the script, find this line:
  AND post_status = 'publish' 
-Right above it, add this line:
  AND {$table_prefix}categories.cat_ID  3
  (Where 3 is the category ID) 

**MOD 2. adds a sapce between posts**
-Origional code
  $the_output .= substr(strip_tags(trim($the_text)) , 0, $ddle_chars);
  $the_output .= '';
-New code
  $the_output .= substr(strip_tags(trim($the_text)) , 0, $ddle_chars);
  $the_output .= '';
-Added the second  to this line of code

**MOD 3. fixes the situation of having only one comment, origional code does not adress if there is only one comment**
-This mod also rearranges the Comment output code to match my theme.
-Origional code  
  if ($ddle_comment_num) {
    $the_output .= $num_comments . ' Comment';

    if ($num_comments != 1) {
      $the_output .= 's';
    }

    } else {
      $the_output .= 'Comments';
  }

-It now looks like this
  if ($ddle_comment_num) {
    $the_output .=  '   [Comment';

    if ($num_comments != 1) {
      $the_output .= 's ('.$num_comments.')]';
    } else {
      $the_output .= '('.$num_comments.')]';

  } else {
    $the_output .= 's ('.$num_comments.')]';
  }

**MOD 4. changes the output format**
-Origional Code
$the_output .= '</b>: <a>ID) . '"&gt;' . $posts-&gt;post_title . '</a>';
if ($ddle_show_date) {
			$the_output .= ' - ' . date($ddle_date_format, strtotime($posts-&gt;post_date));
		}
-I made it look like this, 
$the_output .= '</b>: <a>ID) . '"&gt;' . $posts-&gt;post_title . '</a>';
if ($ddle_show_date) {
			$the_output .= date($ddle_date_format, strtotime($posts-&gt;post_date));
		}
-Adding the  to the end of the first line allowed me to setup the format to match the rest of the page
-removing the ' - ' . removed the - from the beggining of the date and comment line

**MOD 5 filters out the sub-categories**
-origional function        
		$last_posts = (array)$wpdb-&gt;get_results("
		SELECT post_date, ID, post_title, cat_name, cat_ID
		FROM {$table_prefix}posts, {$table_prefix}post2cat, {$table_prefix}categories 
		WHERE {$table_prefix}posts.ID = {$table_prefix}post2cat.post_id 
		AND {$table_prefix}categories.cat_ID = {$table_prefix}post2cat.category_id
		AND {$table_prefix}categories.cat_ID  2
		AND post_status = 'publish' 
		AND post_date  2
-This causes the the search to look for categories that have a category perant of 0 meaning they have no perant
		$last_posts = (array)$wpdb-&gt;get_results("
		SELECT post_date, ID, post_title, cat_name, cat_ID
		FROM {$table_prefix}posts, {$table_prefix}post2cat, {$table_prefix}categories 
		WHERE {$table_prefix}posts.ID = {$table_prefix}post2cat.post_id 
		AND {$table_prefix}categories.cat_ID = {$table_prefix}post2cat.category_id
		AND {$table_prefix}categories.cat_ID  2
		{$table_prefix}categories.category_parent = 0
		AND post_status = 'publish' 
		AND post_date get_var("SELECT post_content FROM " . $table_prefix . "posts WHERE ID=" . $posts-&gt;ID);
	$the_output .= '';
	$the_output .= substr(strip_tags(trim($the_text)) , 0, $ddle_chars);
	if (sizeof(strip_tags(trim($the_text))) &gt; $ddle_chars) {
	$the_output .= "...";
}
-The new code
if ($ddle_excerpts) {
	$the_text = $wpdb-&gt;get_var("SELECT post_content FROM " . $table_prefix . "posts WHERE ID=" . $posts-&gt;ID);
	$the_output .= '';
				
	if ( strlen(strip_tags(trim($the_text))) &gt; $ddle_chars) {
		$the_output .= substr(strip_tags(trim($the_text)) , 0, $ddle_chars);
		$the_output .= " ... " . '<a>ID) . '"&gt;[More]</a>';
	} else {
		$the_output .= $the_text;
	}

	$the_output .= '';
}

Hehehe!

You sent me some code so I could have the latest post, no matter the category, showing on a page. Shall I forward it to you in email?

Thanks

Hi again Admin!

It’s been a while, but I have been very busy with the new baby! hehe

I now get this error when trying to use the code you sent me:

WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
SELECT post_content FROM abblogwp_posts WHERE ID=

Any ideas?

Thanks

Andy