Subversion Repositories eFlore/Applications.del

Rev

Rev 1312 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1312 Rev 1313
Line 499... Line 499...
499
	
499
	
500
		// Charger les obs images / images
500
		// Charger les obs images / images
501
		// récupérer les ids
501
		// récupérer les ids
Line 502... Line 502...
502
		// récupérer les observations
502
		// récupérer les observations
503
 
503
 
504
		$requeteImages = 'SELECT SQL_CALC_FOUND_ROWS *, di.mots_cles_texte as mots_cles_texte_image FROM del_obs_image doi '.
504
		$requeteImages = 'SELECT  *, di.mots_cles_texte as mots_cles_texte_image FROM del_obs_image doi '.
505
						'INNER JOIN del_image di ON doi.id_image = di.id_image '.
505
						'INNER JOIN del_image di ON doi.id_image = di.id_image '.
506
						'ORDER BY id_observation DESC'.
506
						'ORDER BY id_observation DESC'.
-
 
507
						$this->gestionBdd->getLimitSql();
-
 
508
		$liaisons = $this->bdd->recupererTous($requeteImages);
-
 
509
 
-
 
510
		
Line 507... Line 511...
507
						$this->gestionBdd->getLimitSql();
511
		$nbImages = 'SELECT count(id_image) as nb FROM del_obs_image';
508
		$liaisons = $this->bdd->recupererTous($requeteImages);
512
		$requeteNbImages = $this->bdd->recupererTous($nbImages);
Line 509... Line 513...
509
		
513
		
510
		$total = $this->compterImages();
514
		$total = (int) $requeteNbImages[0]['nb'];
511
		$this->navigation->setTotal($total);
515
		$this->navigation->setTotal($total);