WordPress Custom Query Help

mikes02

I am trying to setup a custom Archives page and I am trying to obtain all Posts for a given page and loop through them and link them by title on the page, however I want to exclude a particular category (3) from the query, where am I going wrong with this, it is returning all posts for the month from both of my categories instead of just the one.

<ul>
						<?php	
                        $titles = $wpdb->get_col(
						"SELECT DISTINCT post_title FROM $wpdb->posts ".
						"INNER JOIN $wpdb->terms AS t ".
						"INNER JOIN $wpdb->term_taxonomy AS tt ON tt.term_id = t.term_id ".
						"INNER JOIN $wpdb->term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id ".
						"WHERE tr.term_taxonomy_id != 3 AND post_type = 'post' AND post_status = 'publish' AND MONTH(post_date) = '".$month."' AND YEAR(post_date) = '".$year."' ORDER BY post_date DESC"
						);
						foreach($titles as $title) :
                        ?>
                        <li><a href="<?php bloginfo('url'); ?>/<?php echo $title; ?>"><?php echo $title;?></a></li>
                        <?php endforeach;?>
                    </ul>

Bonesnap

mikes02;10991374 wrote:
...it is returning all posts for the month from both of my categories instead of just the one.

Isn't this what you want? You said you want to exclude a category (#3), which suggests to me that you have at least three categories. Going by your query, it's going to exclude the third category, but still get posts from categories #1 and #2.

Are you trying to get posts from only ONE category?

mikes02

Actually, I made it unnecessarily complicated, I ended up using query_posts with the $year and $month variables and excluded the category I didn't want and it worked.