Baserrien fitxak inprimatu (PHP)
<?php
$output = '';
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;
?>
Amarik gabeko zenbakidun sarrerak
<?php
$result = db_query('SELECT b.*, n.teaser FROM berba b LEFT JOIN node n ON b.nid = n.nid LEFT JOIN node_relations nr ON nr.type = "Adiera" AND b.nid = nr.nid WHERE b.pisu > 0 AND ISNULL(nr.pnid) = 1 ORDER BY b.gako ASC');
$output = '';
while($row = db_fetch_object($result)){
$output .= '<p>'.$row->teaser.'</p>';
}
print $output;
?>