Skip to main content

List Drupal nodes

<?php

$sql="SELECT `nid`,`vid`,`type`,`language`,`title`,`uid`,`status`, FROM_UNIXTIME(`created`),FROM_UNIXTIME(`changed`) FROM `node`  LIMIT 10";

//$sql="SELECT * FROM {node}";

db_query($sql);

 $query = db_query($sql);

  while ($row = db_fetch_array($query)) {
$headers=array_keys($row);
    $rows[] = $row;
   
  }

  // Make the table...
  $output = theme('table', $headers, $rows);

  // Return the output with the pager attached to it. The pager is the box underneath the table that allows people to jump to the next page.

return $output;