 |
 |
LAATSTE NIEUWS |
 |
|
$nQry = mysql_query ("SELECT * FROM nieuws ORDER BY datum DESC LIMIT 0,5;");
while ($nData = mysql_fetch_assoc ($nQry)) {
echo ' | ';
echo ''.date ("d-m-Y", strtotime ($nData['datum'])).' - | ';
echo ''.$nData['titel'].' | ';
echo ' | ';
}
?>
|
 |
|
 |
NIEUWSTE FOTOALBUM |
 |
$nAlbum = mysql_result (mysql_query ("SELECT MAX(datum) FROM fotoalbum;"), 0);
$sql = "SELECT * FROM fotoalbum WHERE datum='".date ("Y-m-d", strtotime ($nAlbum))."';";
$qry = mysql_query ($sql);
$data = mysql_fetch_assoc ($qry);
$Map = opendir ("fotoalbum/".$data['map']);
while ($Foto = readdir($Map))
if (preg_match("/.*\.jpg/i", $Foto) && $Foto <> "." && $Foto <> "..") $bestandsLijst[] = $Foto;
echo "
".$data['naam']." Datum: ".date ("d-m-Y", strtotime ($data['datum']))." | \n";
$bestandsLijst = array ();
?>
|
 |
|