Other Posts from Cat plugin for WordPress

i’m wondering if there is a way to display the 10 most recent posts of the same category at a custom place of the page, i’d like to insert it in another div but can find a way to do that…

Thanks for your great work.

I have the same intention than Adil (#91): to exclude some categories (or to include just a few). I tried the solution proposed in #92, but nothing happens (it shows all the categories of the post).

Any ideas? Thanks in advance.

Hi, I found a problem and fix it.
I had a post with “&” in it.
So I’ve added htmlspecialchars to the output, like this htmlspecialchars($lpost->post_title), now the code is valid.

Great plugin. Thanks !

I uesd this plugin. Its working. But I need the php code to insert in my template. Please help me out.

Just edit your plugin and take the text from the latest version and copy paste.

hey,
thanks for the plugin. it’s great. honestly
i’d like to know, though, how can i go about adding excerpts next to the listed titles. (i’ve seen two other users interested in doing the same thing. i would appreciate it if you could email me the solution as well or post it here. or even better, maybe adding it in a future version?)
i would also be interested in knowing if there’s a way of listing related posts randomly.
cheers!

This plugin is working PERFECTLY if I place the code in the post. Otherwise - the “automatic” trigger doesn’t seem to work.

I could manage this way - but I’d love to have it work automatically l….

I added the following to my sidebar.php and it is working just nicely out of the loop:

“ddop_show_posts();”

These are of course contained with the standard php tag, which I can’t out into a comment.

sorry if this has been asked before, but I only read one page of the 9 comments pages

can I somehow use a tempalte tag to get the output? I would like this after my post rather than inside my post.

Hi - thanks for the plugin, great idea. I’m having a problem with it at the moment though. It works fine until I try to output to the sidebar instead of underneath the post… just returns blank… any ideas?

I have the same problem as aure. I installed wordpress 2.3 and its spits out errors on all my posts now. Will there be an update?

Please, give me a file “dd-posts-from-cat.txt” v1.3 !!!
I need it !

Ok, got back to this. The fix was as easy as changing the query (line 329) to post_type != ‘page’ instead of post_type = ‘page’. Evidently it was intentional to show other pages in case of there not being enough actual posts in the same category? Not sure, but this makes more sense to me. Thanks!

This is exactly the plugin I need for my site but like 115 and 117 it simply shows nothing at all. I manually inserted tags in posts and used the php code in the loop and still nothing.

Just tried the plugin but same as Christian 115 nothing happens, I tried with php code 113, still nothing, any idea (I’m on wordpress 2.2.1)

After installing and activating the plugin it seems to work, but I onl get the empty ddop div tag. Anyone ideas how to fix this and/or what the reason could be?

Fixed the problem the page called a plugin but just need a return on the page to work. Thanks and keep up the good work.

Alex

Further ideas:
The plugin show ‘X posts from this category, or subcategory’? (If a post were in both a category and it’s subcategory, only the subcategory would be shown)

There should be a possibility of putting the ‘number of posts found’ into the header (e.g. if the header is ‘X posts from (Category)’, but only X-1 posts are found, then X-1 should be used.

This is working wonderfully for new posts! It will make our site much more usable. But not for existing posts - so far, anyway, even if we open, edit, and repost. We’ll keep playing with it. (Running 2.1.2 - as per host - which changes WP versions slowly)

So maybe will be able to solve problem on this end - but thought it worth adding to feedback.

Thanks!

It works great now! Thanks!!! One suggestion: Maybe if there are no other posts in a certain category (new category) there shouldn’t be any mention of that category below the post as it will simply show up empty.

Other than that it’s perfect.

The plugin sounds great, and it works, however, I also get this nasty error message in the beginning of evry post:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/ja2/02/722/00000013/htdocs/tlab/wp-content/plugins/dd-posts-from-cat.php on line 199

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/ja2/02/722/00000013/htdocs/tlab/wp-content/plugins/dd-posts-from-cat.php on line 199

So I had to disable it. Any advise?

Right now the results will show at teh bottom of the post itself. But I would like to show the results in a sidebar. is there any way to do that?

Further UPDATE: It’s only showing the Pages as part of the default category. The other categories work fine.

Hi, this plugin is exactly what I need to create an easy internal “related links” at the end of each post. However, it is currently listing the posts in that category first (correct) and then Pages for the remaining links. How can I edit to only list posts?

Thank you for this plugin-I have been looking for this for some time and I like the way you’ve done it. Could you please make it possible to have more control over the categories chosen? For instance, I want to exclude some categories (I have some categories that are too general, others that divide posts according to volume/issue–I want to be able to list relevant posts according to categories that describe content only (for instance “international” “videos” “music” and not “Volume 9″. Thanks a lot–hope you have the chance to do this.

Very nice plugin, it’s indeed a useful tool for my blog, thank you so much

Is it possible to show content along with the Title using the_excerpt or the_excerpt_reloaded? I’m trying to make a two column page that shows only posts from the same category, and the only solution I can find is your plug-in on the left, and a loop on the right column with an offset by the number in the left.

Great Plugin.

How do i display latest posts in current category in sidebar ?

I want to display all the posts under the current category in sidebar.

If i just place this code in sidebar

<?php echo ddop_show_posts(); ?>

it will show wrong category posts.

I know it works if it is used in the loop, but isn’t there any way to grab the category id by placing some code in loop and displaying links outside the loop ?

Any help will be highly appreciated.

Thanks. It worked great!

Hi. Thanks for this great plugin.

I’d like to integrate this into my current theme. I don’t want the titles to show up UNDER the posts but NEXT TO them. And I don’t want to manually configure this for every single post, by writing for each post.

I tried to include this in the single.php but it didn’t work.

How can I make it?

Thanks.

OK, all is right. Your plugin is very fantastic … my english is quite bad, and some of your options were not easy to understand when you don’t speak like Shakespeare So … the only thing which misses to your plugin, is the possibility to put where you want (in my example : on the right of the post)

doesn’t work for me …
1. first problem : if I chek “show under the post” … I choose 5 post … and I have in H2 > “The last 5 articles from “Category” … and I have not 5, but 10

2. The worst : I WANT to place when I want inside the post page (and whynot the index, but in this case, the post page) the code … and … it’s not interpreted. When I see the source, I see :

<dt>Derniers articles</dt>
<dd> <!-- ddpostsfromcat --> </dd></dl>

So … I’m on WP 2.1.2 and php5.2 . A feature would be great : you have the choice between the “current” category and “all” categories. But if I take my example (a post inside 2 or 3 categories in same times, for example : Bars, Concerts, Photos … it would be nice to have an option to list the xxx posts from each category where the post is. Possible ?

Great Plugin!

As a newbie, I was wonderng if it is possible to call the function from outside the loop , specifying the category, such as .

As I understand i can call the php functions to some other file, and execute the query, but it must be to an specific category?

Thanks!

Hi. Just installed this plugin on WP 2.1. Two things… The plugin is installed fine and shows the other posts in the same categories fine. However, just where the post begins on my single.php page, I get the following error:

Warning: mysql_num_rows(): supplied argument is not a valid 
MySQL result resource in /home/virtual/site2/fst/var/www/html/
content/wp-content/plugins/other-posts-from-cat.php on line 195

Warning: mysql_num_rows(): supplied argument is not a valid 
MySQL result resource in /home/virtual/site2/fst/var/www/html/
content/wp-content/plugins/other-posts-from-cat.php on line 195

However, the plugin does seem to be working as it shows the other posts at the bottom of the current post.

My 2nd question is, I don’t want to show these categories and other X posts from them at the bottom of my main post, but in the sidebar. How can I do that?

Thanks
Cent

Fine plugin just what I needed for, The admin tab is a great addition too. Now my question is about the option to output post from multiple cats. Is it possible to get to lists next to each other instead of under each other? Perhaps with CSS floats or by using good old tables. thanks

The () comes from here:

if ($ddop_other_cats && !$ddop_sep_cats) {

	// show other cats too, but in one list

	$category_check = " WHERE (";
		
	$i = 1;

	foreach ($cat_list as $c) {

		$category_check .= " category_id = " . $c->cat_ID . " ";

		if ($i < sizeof($cat_list)) {
			$category_check .= " OR ";
		}

		$i++;

	}

	$category_check .= ") ";

The $category_check is throwing an error and that’s why the () ends up empty.

I’ve tried !=, and NOT IN (7,8) - all produce the same error:

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 ') 
			AND wp_posts.ID = wp_post2cat.post_id 
			 AND ID != 59  
			AND post_s' at line 3]

			
			SELECT DISTINCT ID, post_title, post_date, post_category
			FROM wp_posts, wp_post2cat 
			 WHERE () 
			AND wp_posts.ID = wp_post2cat.post_id 
			 AND ID != 59  
			AND post_status = 'publish' 
			ORDER BY post_date  DESC  
			LIMIT 5

I was trying to do something like that before but didn’t have the ‘Check all categories that current post is in’ box checked. Now it is but I’m getting a MySQL syntax error when I try to exclude more than one category (as per your example). If I have:

WHERE post_id = {$c_post}
AND cat_ID !=7
AND {$table_prefix}categories.cat_ID = {$table_prefix}post2cat.category_id

it’s OK, but as soon as I do this:

WHERE post_id = {$c_post}
AND cat_ID !=7
AND cat_ID !=8
AND {$table_prefix}categories.cat_ID = {$table_prefix}post2cat.category_id

I get: “You have an error in your SQL syntax”

I notice this in the plugin script:

$ddop_excluded_cats = get_option('ddop_excluded_cats');

but it doesn’t appear to be used anywhere else. How do I go about implementing excluding certain categories?

Looks great but I’ve to wait to the missing too before use it really…

Jorge: I think I forgot to put the files in their own folder. You should create a folder named ddop under your plugins directory and place dd-posts-from-cat.php and ddop-es_ES.mo inside it.

The zip in http://cachuflos.net/wp-content/uploads/ddop.zip has been updated accordingly.

Thanks for the plugin! I’m still new to Wordpress. I installed the international version but I don’t know how to enable the Spanish translation or how to make the dates appear in Spanish. I’ve resorted to using numbers for the time being. Any pointers will be much appreciated.

I have fully internationalized your plugin, it now show the dates in the appropiate language. I’d send you the files but I couldn’t find your e-mail, so you can download them here: http://cachuflos.net/wp-content/uploads/ddop.zip

Files: dd-posts-from-cat.php, ddop.pot, Spanish .po and .mo

Ahh, sorry, I feel so silly, I just realised there was more than one page of comments, and found the answer on one of those. Thank you anyway, I will be sure to mention this excellent plugin to my friends!

He, I knew it wasn’t going to work but I just had to try… Ok, if there’s someone interested, I’ll come back again and do my best to post the code.

you rulez man.
helped me to put the list on a new sidebar.

[...] 這個 Other Posts From Cat 還蠻常見的，就是在文章後附上和這文章相同類別的最近 n 筆文章 ~ [...]

[...] 　　日志现在用上了Other Posts From Cat这一个插件，它可以在每篇日志底部列出跟该日志分于同类的其它日志。使用起来非常方便，在后台激活就行，所有更改都在后台完成，不用改代码文件。而且，也可作为相关日志插件Related posts的代替。推荐使用！ [...]

Admin: Much appreciated. How would you like me to credit you on my website?

Admin: Yes, show the last X posts from the categories this post is in. I’m assuming it wouldn’t be too difficult!

Thanks for the plugin again.

That works. Thanks again for a terrific plugin.

Hello there,

Great plugin. But it doesn’t seem to display the links if the single.php template is changed to use an alternative to the_content.

I’m trying to stop WP from applying the texture filters by getting my content before it’s filtered. For example, if I replace the_content with echo get_the_content or echo $post->post_content, I’ve successfully bypassed the automatic text formatting, but your plugin stops displaying links.

I’ve tried editing the plugin, modifying add_filter('the_content', 'ddop_generate'); to correspond to the applicable alternative mentioned above, but still no links are displayed. (Though, admittedly, I may be barking up the wrong tree here.)

And as long as I’m thinking wishfully, how about a way to display the links _after_ the postmetadata?

Thanks a bundle for all your effort to date.
http://www.ardamis.com/

Thanks in advance, that works!!

Hai,
I’m a beginer, and I would like to put your plugin in my website.
I have wrote in sidebar but it doesn’t work -Call to undefined function: ddpostsfromcat()- could you please help me on this issue

Thanks a lot
gaga

Ooops, I spoke a little too soon. The code you suggested only excluded the plugin from displaying anything if the first category was the one in the if statement. I wanted it to skip that category and list for the next category the post is listed under. (Also, it could be useful to list the latest posts in other categories that the posts belongs to also for multi-category posts, but I didn’t implement that. It would require a loop).

I added a little more code and shifted the position of the code to go before the header so the proper category name would be displayed. Here is the code:

	$c_post = $post->ID;
	$c_cat = get_the_category(); 
	$c_cat = $c_cat[0];

	$curr_cat_id = $c_cat->cat_ID;
	if ($curr_cat_id == 5) {
	$c_cat = get_the_category(); 
	$c_cat = $c_cat[1];}
        $curr_cat_id = $c_cat->cat_ID;
        if ($curr_cat_id == 5) return "";

	// fix up header
	$ddop_header = str_replace('%C', $c_cat->cat_name, $ddop_header);