I have a {content_type_answers}
and this table doesn't has a title row, how can i merge it with {node}
to get node titles?
$result = db_query("SELECT {node}.title, {node}.nid FROM {content_type_answers} cta, node WHERE {cta}.nid = {node}.nid");
while($node = db_fetch_object($result) {
$nodes[] = array($node->title, $node->nid);
}
Question: how can i select {node}.title from table {content_type_answers} if in this table no title row at all?