"._("proprietaire"); 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."proprietaire LEFT JOIN ".DB_PREFIXE."civilite ON proprietaire.civilite=civilite.civilite "; // SELECT $champAffiche = array( 'proprietaire.proprietaire as "'._("proprietaire").'"', 'civilite.civilite as "'._("civilite").'"', 'proprietaire.nom as "'._("nom").'"', 'proprietaire.prenom as "'._("prenom").'"', 'proprietaire.adresse1 as "'._("adresse1").'"', 'proprietaire.adresse2 as "'._("adresse2").'"', 'proprietaire.cp as "'._("cp").'"', 'proprietaire.ville as "'._("ville").'"', ); // $champNonAffiche = array( ); // $champRecherche = array( 'proprietaire.proprietaire as "'._("proprietaire").'"', 'civilite.libelle as "'._("civilite").'"', 'proprietaire.nom as "'._("nom").'"', 'proprietaire.prenom as "'._("prenom").'"', 'proprietaire.adresse1 as "'._("adresse1").'"', 'proprietaire.adresse2 as "'._("adresse2").'"', 'proprietaire.cp as "'._("cp").'"', 'proprietaire.ville as "'._("ville").'"', ); $tri="ORDER BY civilite.civilite ASC NULLS LAST"; $edition="proprietaire"; $selection=''; if ($retourformulaire== 'civilite') { $selection=" WHERE (proprietaire.civilite ='".$idx."')"; } $sousformulaire = array( 'parcelle',); ?>