/ Published in: PHP
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
$type = 'blog'; $status = 1; $sql = "SELECT * FROM {node} n WHERE type = '%s' AND status = %d ORDER BY n.created DESC"; $pager_num = 0; // This is the first pager on this page. We number it 0. $result = pager_query(db_rewrite_sql($sql), 10, $pager_num, NULL, $type, $status); 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, $pager_num);