Subversion Repositories eFlore/Applications.cel

Rev

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

Rev 3504 Rev 3506
Line 207... Line 207...
207 
		$motCleP = Cel::db()->proteger($mot_cle);
 207 
		$motCleP = Cel::db()->proteger($mot_cle);
208 
		$idUtilisateurP = Cel::db()->proteger($user_id);
 208 
		$idUtilisateurP = Cel::db()->proteger($user_id);
Line 209... Line 209...
209 
 
 209 
 
210 
		$sousRequete = "SELECT id FROM {$this->table_mots_cles} ".
 210 
		$sousRequete = "SELECT id FROM {$this->table_mots_cles} ".
211 
			"WHERE name = $motCleP ".
 211 
			"WHERE name = $motCleP ".
212 
			"AND userId = $idUtilisateurP ";
 212 
			"AND user_id = $idUtilisateurP ";
213 
		$requete = "DELETE FROM {$this->table_liaison} ".
 213 
		$requete = "DELETE FROM {$this->table_liaison} ".
214 
			"WHERE {$this->id_element_lie} = $idElementLieP ".
 214 
			"WHERE {$this->id_element_lie} = $idElementLieP ".
215 
			"AND {$this->id_mot_cle} IN ($sousRequete) ".
 215 
			"AND {$this->id_mot_cle} IN ($sousRequete) ".