"; // définition de variables $open_folder = "

"; $closed_folder = "

"; $up_folder = "

"; $document = "

"; function select($ref, $id) { global $id_empr; // retourne le code javascript changeant l'adresse de la page pour affichage des notices // $ref -> type de donnée (editeur, collection) // $id -> id de l'objet recherché return "window.parent.document.location='../../../../catalog.php?categ=search&mode=2&etat=aut_search&aut_type=$ref&aut_id=$id&no_rec_history=1'; return(false);"; } if($coll_parent) { // affichage des enfants de la collection $coll_parent $requete = "SELECT * FROM publishers, collections, sub_collections"; $requete .= " WHERE publishers.ed_id=collections.collection_parent"; $requete .= " AND collections.collection_id=sub_collections.sub_coll_parent"; $requete .= " AND sub_collections.sub_coll_parent=$coll_parent"; $requete .= " ORDER BY sub_collections.sub_coll_name"; $result = mysql_query($requete, $dbh); $item = $item=mysql_fetch_object($result); print "$up_folder...
"; print $open_folder."ed_id)."\">".$item->ed_name."
"; print "

$open_folder"; print "collection_id)."\">".$item->collection_name."

"; print "

$document"; print "sub_coll_id)."\">".$item->sub_coll_name."

"; while($item=mysql_fetch_object($result)) { print "

$document"; print "sub_coll_id)."\">".$item->sub_coll_name."

"; } } else { if($ed_parent) { // affichage des enfants de l'éditeur $ed_parent print "".$up_folder.'...
'; // c'est Eric qui m'a dit ça. Merci Eric ;-) (de toute façon, j'ai jamais aimé les dimanches). $requete = "SELECT * FROM publishers, collections"; $requete .= " LEFT JOIN sub_collections ON collections.collection_id=sub_collections.sub_coll_parent"; $requete .= " WHERE publishers.ed_id=collections.collection_parent"; $requete .= " AND publishers.ed_id=$ed_parent"; $requete .= " ORDER BY collections.collection_name"; $result = mysql_query($requete, $dbh); $item = mysql_fetch_object($result); print $open_folder."ed_id)."\">".$item->ed_name.'
'; if($item->sub_coll_id && $item->sub_coll_parent==$item->collection_id) $image = "$closed_folder"; else $image = $document; print "

".$image."collection_id)."\">".$item->collection_name.'

'; while($item=mysql_fetch_object($result)) { if($item->sub_coll_id && $item->sub_coll_parent==$item->collection_id) $image = "$closed_folder"; else $image = $document; print "

".$image."collection_id)."\">".$item->collection_name.'

'; } } else { if ($limite_affichage=="") $restriction = " limit 0,30 "; else $restriction = ""; print "$msg[tout_afficher]
"; // affichage de la liste des éditeurs (1er niveau) $requete = "SELECT * FROM publishers LEFT JOIN collections"; $requete .= " ON publishers.ed_id=collections.collection_parent"; $requete .= " GROUP BY ed_name ORDER BY ed_name $restriction "; $result = mysql_query($requete, $dbh); while($editeur=mysql_fetch_object($result)) { if($editeur->collection_id) $image = "$closed_folder"; else $image = $document; print $image."ed_id)."\">".$editeur->ed_name."
\n"; } if($ancre) print $j_offset; } // fin clause ed_parent } // fin clause coll_parent mysql_close($dbh); // affichage du footer print "