/** * Get the main image for an event * * @param unknown $idEvenement * @return array of idHistoriqueImage and dateUpload */ public function getImagePrincipale($idEvenement) { $selectAll = "\n\n \t\t\tSELECT evt.idImagePrincipale as idImage, hi.idHistoriqueImage , hi.dateUpload\n \tFROM evenements evt\n \tLEFT JOIN historiqueImage hi on hi.idImage = evt.idImagePrincipale\n \tWHERE evt.idEvenement = {$idEvenement}\n \tAND evt.idImagePrincipale != 0\n \t\t\t"; $resUnion = $this->connexionBdd->requete($selectAll); $arrayImg = array(); while ($fetchUnion = mysql_fetch_assoc($resUnion)) { $arrayImg[] = $fetchUnion; } if (empty($arrayImg)) { $a = new archiAdresse(); $resBrol = $a->getFirstImageFromEvenement($idEvenement); } return $imageInfo; }