54,7 → 54,7 |
$requete = (($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '. |
'FROM coel_meta_liste_valeur '. |
"WHERE cmlv_ce_parent = {$p['ceParent']} ". |
"AND cmlv_id_valeur LIKE {$p['idValeur']}". |
"AND cmlv_id_valeur LIKE {$p['idValeur']} ". |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cmlv_id_valeur ASC').' '; |
$requete_compte = $requete; |
$requete .= "LIMIT $this->start,$this->limit "; |
95,7 → 95,7 |
$requete = (($this->distinct) ? 'SELECT DISTINCT' : 'SELECT').' * '. |
'FROM coel_meta_liste_valeur '. |
'WHERE '; |
if ($p['nom'] != "") $requete .= "cmlv_nom LIKE {$p['nom']} AND "; |
if (isset($p['nom']) && $p['nom'] != "") $requete .= "cmlv_nom LIKE {$p['nom']} AND "; |
if (isset($p['ceParent'])) $requete .= " cmlv_ce_parent = {$p['ceParent']} AND "; |
$requete .= " cmlv_id_valeur LIKE {$p['idValeur']} ". |
'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby : 'cmlv_id_valeur ASC').' '; |
109,8 → 109,7 |
if (!is_null($requete)) { |
// Exécution de la requêtre SQL et test d'éventuelles erreurs |
try { |
$resultat = $this->bdd->query($requete)->fetchAll(); |
|
$resultat = $this->bdd->query($requete)->fetchAll(PDO::FETCH_ASSOC); |
if ($resultat === false) { |
$this->messages[] = "La requête a retourné aucun résultat."; |
} else { |