Constructing a multi-table query

[Paul Rothenberg]

Hi all,

Newbie here trying to wrap my head around multi-table queries. I wrote the following to try and do something (albeit I knew inefficiently), but it makes the browser hang. How can I get $post_id in one query?

$query = "SELECT term_id FROM wp_terms WHERE name = '" . $answer . "'";
$termid = $wpdb->get_results($query,ARRAY_A);
$termid = $termid['term_id'];

$query = "SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id = '" . $termid . "'";
$postid = $wpdb->get_results($query,ARRAY_A);
$postid = $postid['object_id'];

the_content($postid);