/**
* 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;
}
