| 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 { |