Fitxategien jarraipena (nodoekiko loturak)

<p><br />
<?php

$result = pager_query('SELECT n.title, n.nid, n.type, u.nid, f.fid, f.filename, f.filepath FROM files f
LEFT JOIN upload u ON f.fid = u.fid LEFT JOIN node n ON u.nid = n.nid', 100);

$rows = array();
while($r = db_fetch_object($result)){
$file_link = !empty($r->filepath) ? l($r->filename, $r->filepath) : '-';
$page_link = !empty($r->title) ? l($r->title, "node/$r->nid") : '-';
$row = array($page_link, $r->type, $r->fid, $file_link);
$rows[] = $row;
}

$output = '';
$headers = array('Orria', 'Mota', 'FID', 'Fitxategiaren izena');
$output .= theme('table', $headers, $rows);
$output .= theme('pager');

print $output;

?></p>