"._("candidature"); $tableSelect=DB_PREFIXE."candidature"; $champs=array( "candidature", "agent", "scrutin", "periode", "poste", "bureau", "recuperation", "note", "decision", "debut", "fin"); //champs select $sql_agent="SELECT agent.agent, agent.nom FROM ".DB_PREFIXE."agent"; $sql_agent_by_id = "SELECT agent.agent, agent.nom FROM ".DB_PREFIXE."agent WHERE agent = ''"; $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_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 = ''"; ?>