Evenementen

'" . date("Y-m-d H:i:s")."' OR `PublishEnd` = '0000-00-0000 00:00:00') ORDER BY `EventStart` ASC "; if ($result = $dbc->query($Rquery)) { if ($result->num_rows) { while($row = $result->fetch_assoc()){ $Amount ++; if($row['EventStart']!= "0000-00-00 00:00:00"){ $Event = strtotime($row['EventStart']); $EvenStartHeader = $date_MY->format($Event); } if($row['PublishEnd']!= "0000-00-00 00:00:00"){ $EndDate = strtotime($row['PublishEnd']); //$PublishEnd = $date_dMY->format($EndDate); $PublishEnd = $date_dm->format($EndDate); }else{ $PublishEnd=""; } if($row['EventStart']!= "0000-00-00 00:00:00"){ $Event = strtotime($row['EventStart']); //$EvenStart = $date_dMY->format($Event); $EvenStart = $date_dm->format($Event); } if ($EvenStart != $PublishEnd){ $EvenStart = date("j", $Event); $PublishEnd = $date_dm->format($EndDate); $DateEvents= "$EvenStart - $PublishEnd"; }else{ $DateEvents = $date_dm->format($Event); } // convert titles to fancy ones $CleanCode = array(" ", "__",",",".","/","\\",")","(","'","\""); $FancyTitle = str_replace($CleanCode, "_", $row['Title']); $FancyTitle = strtolower($FancyTitle).".html"; // Clean text and shorten $row['ShortArticle'] = strip_tags($row['ShortArticle']); if (strlen($row['ShortArticle']) >= 300) { $row['ShortArticle'] = substr($row['ShortArticle'], 0, 300). "..."; } if($row['Category']=="2"){ $WebLink = "/bericht/".$row['ID']."/$FancyTitle"; $Target = "_parent"; $Class= ""; $Description = "".$row['ShortArticle'].""; } if($row['Category']=="48"){ $WebLink = "".$row['WebLink'].""; $Target = "_blank"; $Class= "AddClickNews"; $Description = "Voor meer informatie bezoek je de website."; } if($EvenStartHeader == $EvenStartheck){ //echo "$EvenStartHeader
"; // geen speciale header }else{ if (!empty($EvenStartheck)) echo "
"; echo"
$EvenStartHeader
"; echo"
"; $EvenStartheck = $EvenStartHeader; } // list items echo"
$DateEvents

".$row['Title']."

$Description

"; if($Amount == $result->num_rows){ #echo"
"; echo"
"; } } } } ?>