WordPress Category Posts Plugin v1.0

double woohoo.. A quick look at the database description for wp and…

I modified the ORDER statement to read

$get_posts_in_cat .= “ORDER BY $wpdb->posts.post_date DESC “;

and added this after the order statement.

$get_posts_in_cat .= “LIMIT 10″;

how to use this script??
where to put it?
the readme is not clear..i’m a newbie in wordpress…
please explain step by step example how to use this…

I need to show the excerpt of the post, but I don’t know how! Could anybody help me?

I am totally blown away by your WP Category Posts plug in and the level of support you provide. It’s fantastic and thank you for making such an easy to use feature.

I was wondering if you could tell me how to rescrict the number of posts being displayed.

Thanks again for your help and keep up the good work.

$get_posts_in_cat .= “LIMIT 10″; works perfect for limiting, but I have no way of making the most recent posts display.

$get_posts_in_cat .= “ORDER BY $wpdb->posts.post_date DESC “; generates errors.

This is a great plugin – should definately be included in the standard Wordpress distribution !

I have one small problem though, which only appears when WP Cat Posts is generating the displayed page… so i though the error might lie with the plugin:

Please have a look at http://www.aficionado.dk/
Place mouse cursor over the ‘cigarer’ category. – The ‘on-mouse-over’ displays the text ‘Anmeldelser af cigarer’ – this is ok!

But try to enter the ‘cigarer’ category .. now the ‘on-mouse-over’ suddenly displays Anmeldelser af cigarer – which looks silly.

Please forgive me for being a complete newbie when it comes to messing around in php codes, i’ve learned a little, but unfortunately not enough to solve this – i hope you can help me.

Great plugin, I agree with some of the other comments, this functionality should be in WP core. I have a few suggestions that might make it better.
Option to sort links by date, title, etc
Option to limit number of posts
Option to display category title as a link

If anyone knows how to do these, please let me know. I am not doing very good at learning PHP.

Yes, how do you space out each link, as with and ?
And what did the poster Michael mean when this won’t display recent posts? It doesn’t?

Hi! Will you plug-in enable me to list the posts under the categories in the sidebar?

Thanks,
keith

I added the select, the loop and the echo $post_excerpt … not working … i am using wordpress 2.0 … and it looks like this …
echo ‘‘ . $post_title . ‘‘;
echo $post_excerpt;

whot did i do wrong ? … PS … I suck at PHP … please advise

Hi,
The plugin looks fine, but I can’t find any information on how to use it… pleeease heeelppp. What I need is to have the title of the category above the list of related posts. Is it the proper plugin to do that ?
Thank you,
Gerald

Hi. I found this plugin in the comments of an OnLamp article. However, out of the box, it didn’t do what I needed for my project. Therefore I wrote my own Posts for Category plugin. I hope it proves useful to others just as it did to me. Your work in this plugin no doubt helped me so thanks.

please, can you tell me how to use this plugin with “my post icons” plugin ?

I just tried the excerpt coding you have written here Brian and it will not show the excerpt in the brand new wordpress version. Do you know if its compatible or not? Here is the code I used:

posts.ID, $wpdb->posts.post_title, $wpdb->posts.post_excerpt ,”;
$get_posts_in_cat .= “$wpdb->post2cat.post_id, $wpdb->post2cat.category_id “;
$get_posts_in_cat .= “FROM $wpdb->posts, $wpdb->post2cat “;
$get_posts_in_cat .= “WHERE $wpdb->posts.ID = $wpdb->post2cat.post_ID “;
$get_posts_in_cat .= “AND $wpdb->post2cat.category_id = ‘$catID’ “;
$get_posts_in_cat .= “AND $wpdb->posts.post_status = ‘publish’ “;
$get_posts_in_cat .= “ORDER BY $wpdb->posts.post_title “;

$get_posts_in_cat_result = mysql_query($get_posts_in_cat);

while ($posts_in_cat_row = mysql_fetch_assoc($get_posts_in_cat_result)) {
$post_title = $posts_in_cat_row['post_title'];
$postID = $posts_in_cat_row['ID'];
$post_excerpt = $posts_in_cat_row[’post_excerpt’];

echo ‘‘ . $post_title . ‘‘; echo ‘echo $post_excerpt’;
}
}

?>

Thanks in advance for your help.

Can anyone help me order the posts by date? I need Newbie directions.

Hi, thanks for the information. I Uploaded “wp_category_posts.php” to my “wp-content/plugins” directory. Now I’m in the process of putting the line:

Forgive my ignorance, but I don’t know the proper syntax to replace the number (3) with the ID category I want to display, I called that category: most read.

Can anybody give me some light in that matter, thanks in advance.

I upgraded to WP 2.5 and it started giving me error…
================
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in wp/wp-content/plugins/wp_category_posts.php on line 25
===================

Is there a way around it ?

Thanks in advance !

Thanks for your plug-in!!
Is possible that the list of post automatically update when I add a new post.
Mybe the plug-in have a limit of post to show?
Many thanks in advanced

at wp 2.6

‘Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in …\wp_category_posts.php on line 25′

???

Hi, like others, I would like this plugin working in 2.6. Or is there any other solution?