Display both teaser/excerpt AND body content in node view
I'm building a magazine-type Drupal site. On the node view (complete article/story view) I would like to display both the teaser AND the main body content.
I am using Views2 and the Excerpt module. I have set up a new node View which overrides node/% and am using node-[content type].tpl.php files to enable different layouts for stories assigned to different terms eg. node-story.tpl.php, node-page.tpl.php etc. Instead of using the $content variable to display all the content, I'm pulling out individual values from the node array (eg. $node->content['body']['#value']).
This is all working great for me, except I can't work out how to display the teaser. I thought the Excerpt module would split out the teaser from the main body content and I would be able to treat it as another field, but the only way I seem to be able to see the teaser is by checking "Display only teaser" in the Row style options in Views... and this is at the cost of losing the main body content.
Basically.... help! Please! I've been searching and searching for an answer. Many thanks in advance.
I'm now pulling the teaser
I'm now pulling the teaser straight out of the database:
$sql = "SELECT teaser FROM node_revisions WHERE nid = '$nid'";
$results = db_query($sql); // Run the query
$teaser = db_result($results); // Get the next result, which will/must always be a single field
echo $teaser;
Good idea? Bad idea?