window.location.href='/index.php';";
exit;
}
// article
$query ="SELECT * ";
$query.="FROM Ressource ";
$query.="INNER JOIN Rubrique ON Ressource.IdRubrique = Rubrique.idRubrique ";
$query.="WHERE Ressource.IdRubrique = ".$IdRubriqueCourante." ";
$query.=" AND TypeRessource = ".$TypeRess["Article"]." ";
$query.=" AND (DatePublicationRessource = '0000-00-00 00:00:00' OR DatePublicationRessource <= '".date("Y-m-d H:i:s")."') ";
$query.=" AND (DatePeremptionRessource = '0000-00-00 00:00:00' OR DatePeremptionRessource >= '".date("Y-m-d H:i:s")."') ";
$resultArticle=mysql_query($query);
$returnedArticle=mysql_num_rows($resultArticle);
$rowArticle=mysql_fetch_array($resultArticle);
// article
if ($returnedArticle!=0){
$query="SELECT imgRubrique FROM Rubrique ";
$query.=" WHERE IdRubrique = '".$IdRubriqueCourante."'";
$result=mysql_query($query);
$rowRubrique=mysql_fetch_array($result);
if($rowRubrique["imgRubrique"] !=""){
if (stristr($rowRubrique["imgRubrique"], "upload")) {
$prefixeImg = '';
}else{
$prefixeImg = 'upload/';
}
}
if ($IdRubriqueCourante != rubriqueLSDVE && $IdRubriqueCourante != rubriqueBienVieillir && $IdRubriqueCourante !=1){
if ($rowArticle["TitreRessource"] != "") { ?>
';
}
}
?>
'.$rowArticle["AccrocheRessource"].'
';
}else if ($rowRubrique["AccrocheRubrique"] != "" && $IdRubriqueCourante != rubriqueLSDVE && $IdRubriqueCourante != rubriqueBienVieillir){
echo '
'.$rowRubrique["AccrocheRubrique"].'
';
}?>
= '".date("Y-m-d H:i:s")."') ";
$query.="ORDER BY PositionRubrique ";
$resultArticles=mysql_query($query);
$returnedArticles=mysql_num_rows($resultArticles);
$cptChap=1;
$cptCol=1;
}
?>
Acc�der � la r�servation
Auteur(s):
- Mise à jour
Acc�der � la r�servation
