esoterics

I am curious as to the fix your host had. I too am seeing this code placed on all of my wordpress php pages but it does not exist in any of the files themselves that I can find. Can you provide more information please?

very clean

actually i was jsut able to accomplish the task with this…

Select * FROM wp_posts WHERE post_type='post' AND post_status='publish' AND ID
IN (SELECT post_id FROM wp_post2cat WHERE category_id= 20 ) ORDER BY ID DESC LIMIT 3

Hello,

I am using the same code above and am looking to do the same thing however I am running WordPress 2.2.2 (I know I need to upgrade). How can I make this work for my installation?

$query = "Select * FROM wp_posts WHERE post_type='post' AND post_status='publish' AND ID IN (SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id = $category_id) ORDER BY ID DESC LIMIT 3";

Thanks in advance!