501,13 → 501,17 |
// récupérer les ids |
// récupérer les observations |
|
$requeteImages = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte as mots_cles_texte_image FROM del_obs_image doi '. |
$requeteImages = 'SELECT *, di.mots_cles_texte as mots_cles_texte_image FROM del_obs_image doi '. |
'INNER JOIN del_image di ON doi.id_image = di.id_image '. |
'ORDER BY id_observation DESC'. |
$this->gestionBdd->getLimitSql(); |
$liaisons = $this->bdd->recupererTous($requeteImages); |
|
|
$total = $this->compterImages(); |
$nbImages = 'SELECT count(id_image) as nb FROM del_obs_image'; |
$requeteNbImages = $this->bdd->recupererTous($nbImages); |
|
$total = (int) $requeteNbImages[0]['nb']; |
$this->navigation->setTotal($total); |
|
$idsObservations = array(); |