Submitted by newaction on Mon, 2012-07-02 10:05
<?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;
- Login to post comments