Subversion Repositories eFlore/Applications.cel

Rev

Rev 3578 | Rev 3727 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3578 Rev 3579
Line 55... Line 55...
55
	*
55
	*
56
	* @param int $id_element_lie
56
	* @param int $id_element_lie
57
	* @return array tableau associatif des champs de la table etendu
57
	* @return array tableau associatif des champs de la table etendu
58
	*/
58
	*/
59
	public function consulter($id_element_lie, $langue = "fr") {
59
	public function consulter($id_element_lie, $langue = "fr") {
60
		$requete = "SELECT $this->liste_champs} ".
60
		$requete = "SELECT {$this->liste_champs} ".
61
				"FROM {$this->table_champs_etendus} ce ".
61
				"FROM {$this->table_champs_etendus} ce ".
62
				"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
62
				"INNER JOIN {$this->table_champs_etendus_trad} cet ON ce.field_id = cet.extended_field_id ".
63
				"WHERE cet.language_iso_code = '".$langue."' AND ";
63
				"WHERE cet.language_iso_code = '".$langue."' AND ";
64
		($id_element_lie != "") ? $requete .= " {$this->champ_id} = ".Cel::db()->proteger($id_element_lie) : "";
64
		($id_element_lie != "") ? $requete .= " {$this->champ_id} = ".Cel::db()->proteger($id_element_lie) : "";
65
		$requete .= ' -- '.__FILE__.':'.__LINE__;
65
		$requete .= ' -- '.__FILE__.':'.__LINE__;