require ($_SERVER['DOCUMENT_ROOT']."/Styles/Frame.php"); require ($_SERVER['DOCUMENT_ROOT']."/Fonction/db_connect.php"); //affiche du festival pour l'accueil $query_num = " select max(num) as num from festival"; $result_num = mysql_query($query_num); $row_num = mysql_fetch_array($result_num, MYSQL_ASSOC); $num = ucfirst(htmlspecialchars(stripslashes($row_num["num"]))); $query_affiche = " select affiche, edito from festival where num = '".$num."'"; $result_affiche = mysql_query($query_affiche); $num_result_affiche = mysql_num_rows($result_affiche); for ($affichei=0; $affichei<$num_result_affiche; $affichei++) { $row_affiche = mysql_fetch_array($result_affiche, MYSQL_ASSOC); $affiche = htmlspecialchars(stripslashes($row_affiche["affiche"])); $edito = nl2br(htmlspecialchars(stripslashes($row_affiche["edito"]))); } //récupération des images $query_image = "select nom, auteur, titre, nationalite from festival_image where ID_programme = '0' and ID_manifestation IS NULL and nom LIKE 'Alea_%'"; $result_image = mysql_query($query_image); $num_result_image = mysql_num_rows($result_image); $alea=rand (0,$num_result_image-1); for ($iimage=0; $iimage<$num_result_image; $iimage++) { $row_image = mysql_fetch_array($result_image, MYSQL_ASSOC); $nom_image[$iimage] = htmlspecialchars(stripslashes($row_image["nom"])); $auteur_image[$iimage] = ucwords(htmlspecialchars(stripslashes(@$row_image["auteur"]))); $titre_image[$iimage] = ucfirst(htmlspecialchars(stripslashes(@$row_image["titre"]))); $nationalite_image[$iimage] = ucwords(htmlspecialchars(stripslashes(@$row_image["nationalite"]))); } //je libère la mémoire mysql_free_result($result_affiche); mysql_free_result($result_image); mysql_close($db); ?>