php code to get the 10 latest nodes published ?

$sql = "SELECT * FROM {node} WHERE type = 'page' AND status = 1 ORDER BY created DESC LIMIT 10";
$result = db_query(db_rewrite_sql($sql));
$latest_nodes = array();
while ($data = db_fetch_object($result)) {
  $latest_nodes[] = l($data->title, 'node/' . $data->nid);
}

print theme('item_list', $latest_nodes);