'.$ReaThemeTAB[$i][1].''; } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// //LISTE ANNEE OU VILLE OU PROGRAMME ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// $ReaSThemeSQL = "SELECT * FROM rea JOIN rea_annee ON rea_annee.ReaAnneeID = rea.ReaAnneeID JOIN rea_ville ON rea_ville.ReaVilleID = rea.ReaVilleID JOIN rea_programme ON rea_programme.ReaProgrammeID = rea.ReaProgrammeID JOIN rea_img ON rea_img.ReaImgReaID = rea.ReaID WHERE ReaOnLine = 1 AND rea_img.ReaImgOnLine = 1 AND ReaCatID = ".quote_smart($ReaCatID)." GROUP BY rea.".$ReaTheme."ID ORDER BY ".$ReaTheme."Ordre"; $ReaSThemeSQL = mysql_query($ReaSThemeSQL) or die(mysql_error()); if(mysql_num_rows($ReaSThemeSQL)) { while($ReaSTheme = mysql_fetch_assoc($ReaSThemeSQL)) { if(empty($ReaSThemeID)) { $ReaSThemeID = $ReaSTheme[$ReaTheme."ID"]; } if($ReaSThemeID == $ReaSTheme[$ReaTheme."ID"]) { $ClassClic = 'class="clic"'; } else { $ClassClic = ''; } $M3 .= '
  • '.$ReaSTheme[$ReaTheme."Nom"].'
  • '; } } ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// //DETAILS PROJET ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// $MaxDansListe = 1; $LigneNum = 0; $ReaHTMLTAB = array(); $ReaSQL = "SELECT * FROM rea LEFT JOIN rea_annee ON rea_annee.ReaAnneeID = rea.ReaAnneeID LEFT JOIN rea_ville ON rea_ville.ReaVilleID = rea.ReaVilleID LEFT JOIN rea_programme ON rea_programme.ReaProgrammeID = rea.ReaProgrammeID LEFT JOIN rea_img ON rea_img.ReaImgReaID = rea.ReaID WHERE ReaOnLine = 1 AND ReaCatID = ".quote_smart($ReaCatID)." AND rea_img.ReaImgOnLine = 1 "; if(!empty($ReaSThemeID)) { $ReaSQL .= " AND rea.".$ReaTheme."ID = ".quote_smart($ReaSThemeID); } $ReaSQL .= " GROUP BY ReaID ORDER BY ReaOrdre"; $ReaSQL = mysql_query($ReaSQL); if(mysql_num_rows($ReaSQL)) { $NbEnrg = mysql_num_rows($ReaSQL); if($NbEnrg > 1) { $dataSeek = mysql_data_seek($ReaSQL,$ShowFrom); } while($Rea = mysql_fetch_object($ReaSQL)) { $ReaID = $Rea->ReaID; $ReaHTML = '

    '.$Rea->ReaVilleNom.'
    '.$Rea->ReaVilleRegion.'

    '.$Rea->ReaTitre.'

    Descriptif

    '; if(!empty($Rea->ReaMission)) { $ReaHTML .= '

    Mission
    '.$Rea->ReaMission.'

    '; } if(!empty($Rea->ReaMaitreOuvrage)) { $ReaHTML .= '

    Maître d’ouvrage
    '.nl2br($Rea->ReaMaitreOuvrage).'

    '; } if(!empty($Rea->ReaMaitreOeuvre)) { $ReaHTML .= '

    Maîtrise d’oeuvre
    '.nl2br($Rea->ReaMaitreOeuvre).'

    '; } if(!empty($Rea->ReaSuperficie)) { $ReaHTML .= '

    Superficie
    '.nl2br($Rea->ReaSuperficie).'

    '; } if(!empty($Rea->ReaBudget)) { $ReaHTML .= '

    Montant
    '.$Rea->ReaBudget.'

    '; } if(!empty($Rea->ReaDateEtudes) || !empty($Rea->ReaDateTravaux)) { $ReaHTML .= '

    Calendrier
    '; if(!empty($Rea->ReaDateEtudes)) { $ReaHTML .='Etudes : '.$Rea->ReaDateEtudes.'
    '; } if(!empty($Rea->ReaDateTravaux)) { $ReaHTML .='Travaux : '.$Rea->ReaDateTravaux; } $ReaHTML .= '

    '; } $ReaHTML .= '
    '; if(!empty($Rea->ReaDescriptif)) { $ReaHTML .= '

    Commentaire

    '.nl2br($Rea->ReaDescriptif).'

    '; } $ReaHTML .= '
    '; $ReaHTML .= '
    '; if(isset($Rea->ReaLien) && $Rea->ReaLien!='') { $target = 'target="_blank"'; /* if(isset($Rea->ReaLienBlank) && $Rea->ReaLienBlank==1) { $target = 'target="_blank"'; } else { $target = ''; } */ $ReaHTML .= '

    '.$Rea->ReaLienLabel.'

    '; } //POUR JS $ReaFlashID = $Rea->ReaID; $ReaFlash = '
    '; $LigneNum ++; if ($LigneNum == $MaxDansListe) { //$ActuID = $Actu->ActuID; break; } } } ?> comptoir des projets
    Cette étude est indisponible pour le moment.

    "; } ?>