"._("travaux"); $tableSelect=DB_PREFIXE."travaux"; $champs=array( "travaux", "entreprise", "emplacement", "datedebinter", "datefininter", "observation", "naturedemandeur", "naturetravaux"); //champs select $sql_emplacement="SELECT emplacement.emplacement, emplacement.nature FROM ".DB_PREFIXE."emplacement ORDER BY emplacement.nature ASC"; $sql_emplacement_by_id = "SELECT emplacement.emplacement, emplacement.nature FROM ".DB_PREFIXE."emplacement WHERE emplacement = "; $sql_entreprise="SELECT entreprise.entreprise, entreprise.nomentreprise FROM ".DB_PREFIXE."entreprise ORDER BY entreprise.nomentreprise ASC"; $sql_entreprise_by_id = "SELECT entreprise.entreprise, entreprise.nomentreprise FROM ".DB_PREFIXE."entreprise WHERE entreprise = "; $sql_naturetravaux="SELECT travaux_nature.travaux_nature, travaux_nature.libelle FROM ".DB_PREFIXE."travaux_nature WHERE ((travaux_nature.om_validite_debut IS NULL AND (travaux_nature.om_validite_fin IS NULL OR travaux_nature.om_validite_fin > CURRENT_DATE)) OR (travaux_nature.om_validite_debut <= CURRENT_DATE AND (travaux_nature.om_validite_fin IS NULL OR travaux_nature.om_validite_fin > CURRENT_DATE))) ORDER BY travaux_nature.libelle ASC"; $sql_naturetravaux_by_id = "SELECT travaux_nature.travaux_nature, travaux_nature.libelle FROM ".DB_PREFIXE."travaux_nature WHERE travaux_nature = "; ?>