'.$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"].'';
}
}
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//LISTE PROJET
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$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 AND rea_img.ReaImgVign = 1)
WHERE ReaOnLine = 1
AND rea_img.ReaImgOnLine = 1
AND ReaCatID = ".quote_smart($ReaCatID)."
";
if(!empty($ReaSThemeID)) { $ReaSQL .= " AND rea.".$ReaTheme."ID = ".quote_smart($ReaSThemeID); }
$ReaSQL .= " GROUP BY rea.ReaID ORDER BY rea.ReaOrdre";
$ReaSQL = mysql_query($ReaSQL)or die(mysql_error());
if(mysql_num_rows($ReaSQL))
{
$NbEnrg = mysql_num_rows($ReaSQL);
$n = 1;
$LigneNum = 1;
while($Rea = mysql_fetch_object($ReaSQL))
{
if($n == 1) { $ReaHTML .= ''; }
$ReaHTML .= '| ';
$ReaHTML .= '
';
$ReaHTML .= ' | ';
if($n <= 3) { $ReaHTML .= ' | ';}
if($n == 4) { $ReaHTML .= '
|
';}
if($LigneNum == $NbEnrg)
{
if($n < 4)
{
for($e = $n; $e < 4; $e++)
{
$ReaHTML .= ' | ';
if($e <= 3) { $ReaHTML .= ' | ';}
}
$ReaHTML .= '';
}
}
if($n == 4) { $n = 1; } else { $n++; }
$LigneNum ++;
}
}
?>
Réalisations : architecte urbaniste paysagiste Paris - agence urbanisme Paris
 Mise à jour en cours |
Il n'y a pas de réalisations pour le moment. | ";
}
?>
|
| |
|
|