error) { error_message($msg["searcher_syntax_error"],sprintf($msg["searcher_syntax_error_desc"],$aq->current_car,$aq->input_html,$aq->error_message)); exit(); } $members=$aq->get_query_members("notices","index_wew","index_sew","notice_id"); $where.=$members["where"]." and "; } $where.="niveau_biblio='s' AND niveau_hierar='1'"; $count_query = mysql_query("SELECT count(distinct notice_id) FROM notices WHERE $where", $dbh); $nbr_lignes = mysql_result ($count_query, 0, 0); if(!$page) $page=1; $debut =($page-1)*$nb_per_page; if($nbr_lignes) { $myQuery = mysql_query("SELECT *,".$members["select"]." as pert FROM notices WHERE ".$where." group by notice_id ORDER BY pert desc,index_sew LIMIT $debut,$nb_per_page_a_search", $dbh); $affichage_final = "
"; while($myPerio=mysql_fetch_object($myQuery)) { $class_entete = "even"; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$class_entete'\" "; $url = "./catalog.php?categ=serials&sub=view&serial_id=".$myPerio->notice_id; $isbd = new serial_display($myPerio->notice_id, 1); // lien d'ajout d'une notice mère à un caddie $selector_prop = "toolbar=no, dependent=yes,resizable=yes, scrollbars=yes"; $cart_click_noti = "onClick=\"openPopUp('./cart.php?object_type=NOTI&item=".$myPerio->notice_id."', 'cart', 600, 700, -2, -2, '".$selector_prop."')\""; $affichage_final .= ""; $affichage_final .= ""; $affichage_final .= ""; // affichage des bulletinages associés $myQueryBull = mysql_query("SELECT bulletin_id FROM bulletins WHERE bulletin_notice='$myPerio->notice_id' ORDER BY date_date DESC, bulletin_id DESC ", $dbh); $bulletins=""; while($bul = mysql_fetch_object($myQueryBull)) { $class_suite="odd"; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$class_suite'\""; $bulletin = new bulletinage($bul->bulletin_id); $url = "./catalog.php?categ=serials&sub=bulletinage&action=view&bul_id=".$bul->bulletin_id; // gestion des paniers de bulletins $selector_prop = "toolbar=no, dependent=yes, resizable=yes, scrollbars=yes"; $cart_click_bull = "onClick=\"openPopUp('./cart.php?object_type=BULL&item=".$bul->bulletin_id."', 'cart', 600, 700, -2, -2, '$selector_prop')\""; $bulletins .= ""; if (sizeof($bulletin->expl)) $bulletins .= ""; else $bulletins .= ""; $bulletins .= ""; } $affichage_final .= $bulletins ; } $affichage_final .= "

	".$isbd->isbd."
		".$bulletin->bulletin_numero."	".$bulletin->mention_date."	".$bulletin->aff_date_date."	".$bulletin->bulletin_titre."	".sizeof($bulletin->expl)." ".$msg['bulletin_nb_exemplaires']."

"; print pmb_bidi($affichage_final) ; } else { // la requête n'a produit aucun résultat error_message($msg[46], str_replace('!!user_query!!', stripslashes($user_query), $msg[1153]), 1, './edit.php?categ=serials&sub=collect'); }