"._("bible"); if(!isset($premier)) $premier=''; if(!isset($recherche1)) $recherche1=''; if(!isset($tricolsf)) $tricolsf=''; if(!isset($premiersf)) $premiersf=''; if(!isset($selection)) $selection=''; if(!isset($retourformulaire)) $retourformulaire=''; if (isset($idx) && $idx != ']' && trim($idx) != '') { $ent .= "-> ".$idx." "; } if (isset($idz) && trim($idz) != '') { $ent .= " ".strtoupper($idz)." "; } // FROM $table = DB_PREFIXE."bible LEFT JOIN ".DB_PREFIXE."evenement ON bible.evenement=evenement.evenement LEFT JOIN ".DB_PREFIXE."nature ON bible.nature=nature.nature "; // SELECT $champAffiche = array( 'bible.bible as "'._("bible").'"', 'bible.libelle as "'._("libelle").'"', 'evenement.libelle as "'._("evenement").'"', 'bible.complement as "'._("complement").'"', 'bible.automatique as "'._("automatique").'"', 'nature.libelle as "'._("nature").'"', ); // $champNonAffiche = array( 'bible.contenu as "'._("contenu").'"', ); // $champRecherche = array( 'bible.bible as "'._("bible").'"', 'bible.libelle as "'._("libelle").'"', 'evenement.libelle as "'._("evenement").'"', 'bible.complement as "'._("complement").'"', 'bible.automatique as "'._("automatique").'"', 'nature.libelle as "'._("nature").'"', ); $tri="ORDER BY bible.libelle ASC NULLS LAST"; $edition="bible"; $selection=''; if ($retourformulaire== 'evenement') { $selection=" WHERE (bible.evenement ='".$idx."')"; } if ($retourformulaire== 'nature') { $selection=" WHERE (bible.nature ='".$idx."')"; } ?>