Ikustekoak

<?php
$result = db_query('SELECT nr.pnid, nr.nid cnid, n1.teaser ama, n2.teaser kume FROM node n1 LEFT JOIN node_relations nr ON n1.nid = nr.pnid LEFT JOIN node n2 ON nr.nid = n2.nid WHERE nr.type = "Ikusteko" ORDER BY nr.pnid');

$sin = array();
while($row = db_fetch_object($result)){
$sin[$row->pnid]['nid'] = $row->pnid;
$sin[$row->pnid]['teaser'] = $row->ama;
$sin[$row->pnid]['kume'][$row->cnid] = $row->kume;
}

$zenbat = count($sin);

$output = '';
$p = isset($_GET['p']) ? $_GET['p'] : 0;
$sin = array_slice($sin, $p, 100);
foreach($sin as $k => $v){
$o .= '<div class="box">';
$o .= '<div class="box">'. l($v['nid'], "node/{$v['nid']}/related") .' '. $v['teaser'] .'</div>';
foreach($v['kume'] as $l => $w){
$o .= '<p>'.$w.'</p>';
}
$o .= '</div>';
}

for($i=0;$i<$zenbat;$i+=100){
$pp[] = l($i, 'node/202204', array(), "p=$i");
}
$o .= '<p>'. join($pp, ' | ') .' (Guztira '.$zenbat.')</p>';

print $o;
?>