"._("affectation"); $tableSelect=DB_PREFIXE."affectation"; $champs=array( "affectation", "elu", "scrutin", "periode", "poste", "bureau", "note", "decision", "candidat"); //champs select $sql_bureau="SELECT bureau.bureau, bureau.libelle FROM ".DB_PREFIXE."bureau"; $sql_bureau_by_id = "SELECT bureau.bureau, bureau.libelle FROM ".DB_PREFIXE."bureau WHERE bureau = ''"; $sql_candidat="SELECT candidat.candidat, candidat.nom FROM ".DB_PREFIXE."candidat"; $sql_candidat_by_id = "SELECT candidat.candidat, candidat.nom FROM ".DB_PREFIXE."candidat WHERE candidat = "; $sql_elu="SELECT elu.elu, elu.nom FROM ".DB_PREFIXE."elu"; $sql_elu_by_id = "SELECT elu.elu, elu.nom FROM ".DB_PREFIXE."elu WHERE elu = "; $sql_periode="SELECT periode.periode, periode.libelle FROM ".DB_PREFIXE."periode"; $sql_periode_by_id = "SELECT periode.periode, periode.libelle FROM ".DB_PREFIXE."periode WHERE periode = ''"; $sql_poste="SELECT poste.poste, poste.libelle FROM ".DB_PREFIXE."poste"; $sql_poste_by_id = "SELECT poste.poste, poste.libelle FROM ".DB_PREFIXE."poste WHERE poste = ''"; $sql_scrutin="SELECT scrutin.scrutin, scrutin.libelle FROM ".DB_PREFIXE."scrutin"; $sql_scrutin_by_id = "SELECT scrutin.scrutin, scrutin.libelle FROM ".DB_PREFIXE."scrutin WHERE scrutin = ''"; ?>