include("pageHaut1.inc.php");
include("connexion.inc.php");
$id=$_GET['id'];
if($id)
$sql="SELECT * FROM expositions WHERE idExpo='".$id."'";
else
$sql="SELECT * FROM expositions ORDER BY dateDebut DESC LIMIT 1";
$res=mysql_query($sql);
$info=mysql_fetch_array($res);
$idExpo=$info['idExpo'];
$titre=$info['titreExpo'];
$texte=$info['texteExpo'];
$dateD=$info['dateDebut'];
$dateF=$info['dateFin'];
$artiste=$info['artiste'];
$artisteABN=$info['artisteBN'];
$dateDtemp=explode("-",$dateD);
$jourD=$dateDtemp[2];
$moisD=$dateDtemp[1];
$anneeD=$dateDtemp[0];
$dateDebut=$jourD.".".$moisD.".".$anneeD;
$dateFtemp=explode("-",$dateF);
$jourF=$dateFtemp[2];
$moisF=$dateFtemp[1];
$anneeF=$dateFtemp[0];
$dateFin=$jourF.".".$moisF.".".$anneeF;
?>
expositions | echo $titre; ?> | galerie lesChantiersBoiteNoire | www.leschantiersboitenoire.com
include("pageHaut2.inc.php");
?>
expositions
echo $titre; ?>
if($artisteABN){
$tabABN=explode(",",$artisteABN);
$resNumABN=count($tabABN);
$i=0;
while($i<=($resNumABN-1))
{
$sqlABN="SELECT idArtiste, nom, prenom, vuSurSite FROM artiste WHERE idArtiste='".$tabABN[$i]."'";
$resABN=mysql_query($sqlABN);
$infoABN=mysql_fetch_array($resABN);
$idABN=$infoABN['idArtiste'];
$nomABN=$infoABN['nom'];
$prenomABN=$infoABN['prenom'];
$vuSurSite=$infoABN['vuSurSite'];
if($vuSurSite==1)
echo "".$prenomABN." ".$nomABN."";
else
echo $prenomABN." ".$nomABN;
if($i<($resNumABN-1))
echo" | ";
$i++;
}
if($artiste)
echo " | ";
}
echo $artiste;
?>
if($dateD!=$dateF)
echo "du ".$dateDebut." au ".$dateFin;
else
echo $moisD.".".$anneeD;
?>
$sqlImg="SELECT * FROM photoExpo WHERE expo='".$idExpo."'";
$resImg=mysql_query($sqlImg);
while ($infoImg=mysql_fetch_array($resImg))
{
$idImg=$infoImg['idPhoto'];
$img=$infoImg['photoExpo'];
if(($count%3)==0)
echo"";
echo" | ";
$count++;
if(($count%3)==0)
echo"
| |
";
}
?>
echo $texte; ?>
include("pageBas.inc.php");
?>