Advanced Search

Return to Snippet

Revision: 22865
at January 25, 2010 03:55 by errkk
Initial Code 
$pages = $wpdb->get_results("
	SELECT post_title, ID identificativo FROM wp_posts
	JOIN wp_term_relationships
		ON wp_term_relationships.object_id = wp_posts.ID
	JOIN
		wp_term_taxonomy
		ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
	JOIN
		wp_terms
		ON wp_term_taxonomy.term_id = wp_terms.term_id
	WHERE 
		wp_terms.name = '" . GLOSSARYCAT . "'
	AND
		wp_posts.post_type = 'post'
");
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Query to get posts by category - Wordpress

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, wordpress, category, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP