";
echo "";
//pr�sentation de la rubrique
//affiche_document("presentation_illustrations");
$sql_presentation = "SELECT presentation_bullegalerie
FROM configuration
WHERE id_configuration=1";
$result_presentation = mysqli_query($conn,$sql_presentation);
$presentation = mysqli_fetch_array($result_presentation);
echo nl2br($presentation[presentation_bullegalerie]);
echo "
les derni�res r�actions... archives des commentaires
";
//les derniers commentaires.
$sql_commentaire = "SELECT illustrations_commentaires.id_illustration, illustrations_commentaires.commentaire, illustrations_commentaires.pseudo, illustrations.fichier_thumb
FROM illustrations_commentaires
LEFT JOIN illustrations ON illustrations.id_illustration = illustrations_commentaires.id_illustration
ORDER BY illustrations_commentaires.date_commentaire DESC
LIMIT 0,12";
$result_commentaire = mysqli_query($conn,$sql_commentaire);
echo "";
while($commentaire = mysqli_fetch_array($result_commentaire)) {
echo "";
echo " | ";
echo "$commentaire[commentaire] [$commentaire[pseudo]] | ";
echo " ";
}
echo " ";
echo " | ";
echo "";
//le xx dernieres creations postees
echo "Les 16 derni�res cr�ations ";
$sql = "SELECT id_illustration, pseudo, DATE_FORMAT(date_creation,'%d.%m.%y')as date_creation, date_creation as datec, fichier_thumb
FROM illustrations
WHERE valide=1
ORDER BY datec DESC
LIMIT 0,16";
$result = mysqli_query($conn,$sql);
echo "";
echo "consultez les archives !";
echo " | ";
echo "
";
echo "