\n";
$blogs = db_query("
SELECT n.title, n.nid, n.created, (
SELECT nr.teaser
FROM {node_revisions} nr
WHERE n.nid = nr.nid
ORDER BY nr.vid LIMIT 1) as teaser
FROM {node} n
WHERE n.type = 'story'
ORDER BY n.created DESC LIMIT 2");
while($entry = db_fetch_object($blogs))
{
print "";
print " \n";
}
print "\n";
?>
".l($entry->title, 'node/'.$entry->nid)."
";
print "".date('m/d/Y', $entry->created)."
";
print "
\n";
$blogs = db_query("
SELECT n.title, n.nid, n.created, (
SELECT nr.teaser
FROM {node_revisions} nr
WHERE n.nid = nr.nid
ORDER BY nr.vid LIMIT 1) as teaser
FROM {node} n
WHERE n.type = 'blog'
ORDER BY n.created DESC LIMIT 2");
while($entry = db_fetch_object($blogs))
{
print "";
print " \n";
}
print "\n";
?>
".l($entry->title, 'node/'.$entry->nid)."
";
print "".date('m/d/Y', $entry->created)."
";
print "
Complementary products: