'$anode->teaser' returns nothing. Do I need some extra module installed?

By Newsance on 16 Oct 2008 at 12:51 UTC

'$anode->teaser' returns nothing.

$sql = "SELECT node.teaser" gets a error.

what can be the problem?

Comments

The query fails because the

cog.rusty commented 16 October 2008 at 13:01

The query fails because the teaser is in the 'node_revisions' table, not in the 'node' table.

Sorry, I didn't get it. Can

Newsance commented 16 October 2008 at 13:58

Sorry, I didn't get it. Can you help me to make this work:

$sql = "SELECT node.title, node.nid FROM node WHERE type='page' ORDER BY node.created DESC LIMIT 50" ;
$output .= "<ul>";
$result = db_query($sql);
while ($anode = db_fetch_object($result)) {
$output .= "<li>".l($anode->title, "node/$anode->nid")."</li>";
$output .= "<li>".l($anode->teaser, "node/$anode->nid")."</li>";

}
$output .= "</ul>";
$output .='<div class="more-link">'.l('more', 'node/'.$anode->nid).'</div>';
print $output;

Thanks.