78,9 → 78,9 |
$observations = $this->traiterValeursMultiples($_GET['obsId']); |
|
if (! is_null($observations)) { |
$requete = 'SELECT ce_observation, id_image '. |
'FROM cel_images '. |
"WHERE ce_observation IN ($observations) "; |
$requete = 'SELECT occurrence_id as ce_observation, id as id_image '. |
'FROM photo '. |
"WHERE occurrence_id IN ($observations) "; |
|
$resultats = Cel::db()->requeter($requete); |
|
114,7 → 114,7 |
$idsObs = explode(',', $_GET['ids-obs']); |
$idsObs = array_unique($idsObs); |
// get id images selon id obs |
$req = "SELECT DISTINCT id_image FROM cel_images WHERE ce_observation IN ("; |
$req = "SELECT DISTINCT id as id_image FROM photo WHERE occurrence_id IN ("; |
$req .= implode(',', $idsObs); |
$req .= ");"; |
//var_dump($req); |