I'm a little stuck here. I have a menu in Wordpress with some posts in it. What I would like is to retrieve all the posts as objects.
I think I'm pretty close, but the SQL query doesn't seem to work as I want.
This is wat I have so far:
$querystr = " SELECT wposts.* FROM wp_posts wposts LEFT JOIN wp_postmeta wmeta ON wposts.ID = wmeta.post_id LEFT JOIN wp_term_relationships wrel ON wrel.object_id = wmeta.meta_value LEFT JOIN wp_terms wterms ON wrel.term_taxonomy_id = wterms.term_id WHERE wterms.term_id= $menu_id "; $posts = $wpdb->get_results($querystr, OBJECT);
I'm pretty sure it's a stupid little SQL logic error, but I realy can't find it..