Getting Results for Paged Display

bifurcafe (Alex) — Wed, 21 Nov 2007 12:57:46 GMT

We can present these blog entries a better way: as a page of formatted results with links to more
results. We can do that using Drupal’s pager. Let’s grab all of the blog entries again, only this
time we’ll display them as a paged result, with links to additional pages of results and “first and
last” links at the bottom of the page.



$sql = "SELECT * FROM {node} n WHERE type = 'blog' AND status = 1 ORDER BY

n.created DESC"

$result = pager_query(db_rewrite_sql($sql), 0, 10);

while ($data = db_fetch_object($result)) {

$node = node_load($data->nid);

print node_view($node, TRUE);

}

// Add links to remaining pages of results.

print theme('pager', NULL, 10);

[drupal] Show all nodes of current type

bifurcafe (Alex) — Mon, 19 Nov 2007 10:15:57 GMT



$result = db_query('SELECT n.nid FROM {node} n WHERE n.type = '."'node_type'".' and n.status = 1');

    $output = '';

    while ($node = db_fetch_object($result))

    {

        $output .= node_view(node_load($node->nid), true);

    }



    print $output;

DZone Snippets: drupal code

Getting Results for Paged Display

[drupal] Show all nodes of current type