";
//variables
if(!$page) $page=1;
$debut =($page-1)*$nb_per_page;
$url_base = "./catalog.php?categ=tags";
//requete d'affichage des notices et des tags
$requete="select 1 from tags ";
$r = pmb_mysql_query($requete, $dbh) or die (pmb_mysql_error()."
".$requete);
$nbr_lignes = pmb_mysql_num_rows($r);
$requete="select id_tag,libelle,num_notice,user_code,dateajout,index_l,DATE_FORMAT(dateajout,'".$msg[format_date]."') as ladate,
empr_login, empr_nom, empr_prenom,
niveau_biblio, niveau_biblio, notice_id
from tags left join empr on empr_login=user_code
left join notices on notice_id=num_notice
order by index_serie, tnvol, index_sew ,dateAjout desc
limit $debut,$nb_per_page ";
$r = pmb_mysql_query($requete, $dbh) or die (pmb_mysql_error()."
".$requete);
if (pmb_mysql_num_rows($r)) {
//affichage des notices
print $begin_result_liste;
$res_final = "";
$notice_id=0;
while (($loc = pmb_mysql_fetch_object($r))) {
if ($notice_id!=$loc->notice_id) {
if ($notice_id!=0) $res_final .= "
" ;
$notice_id=$loc->notice_id;
$deb = 1 ;
if($loc->niveau_biblio != 's' && $loc->niveau_biblio != 'a') {
// notice de monographie
$display = new mono_display($loc->notice_id, 6, $link, 1, $link_expl, '', $link_explnum,1, 0, 1, 1);
$res_final .= pmb_bidi($display->result);
} else {
// on a affaire à un périodique
$serial = new serial_display($loc->notice_id, 6, $link_serial, $link_analysis, $link_bulletin, "", $link_explnum_serial, 0, 0, 1, 1, true, 1 );
$res_final .= pmb_bidi($serial->result);
}
$res_final .= "
" ;
print $res_final ;
}
print aff_pagination ($url_base, $nbr_lignes, $nb_per_page, $page, 10, false, true) ;
echo "