include('include/script.php');
$id = $_GET['id'];
if (!isset($id) or empty($id))
$id = 17;
include('include/top.php');
openDB();
$tblContent = runQuery('SELECT Titel, Content FROM content WHERE Id=' . $id);
$row = mysql_fetch_array($tblContent);
if (!empty($row['Titel']))
echo '' . $row['Titel'] . '
';
echo $row['Content'];
switch ($id) {
case 7: // Foto's
?>
$tblContent = mysql_query('SELECT Id, Foto, Titel, Omschrijving FROM foto');
echo '
Beschrijving | Foto |
';
while ($row = mysql_fetch_row($tblContent)) {
echo " $row[3] | ";
echo '![' . $row[2] . '](images/restauratie/thumbnails/' . $row[1] . ') |
';
}
echo '
';
break;
case 14: // Links
$tblContent = runQuery('SELECT CategorieId, Categorie, Titel, Omschrijving, URL FROM linkscategorie AS LC LEFT JOIN links AS L ON LC.Id = L.CategorieId ORDER BY LC.Categorie, L.Titel');
$intCategorieId = 0;
while ($row = mysql_fetch_array($tblContent)) {
if ($intCategorieId != $row['CategorieId']) {
$intCategorieId = $row['CategorieId'];
echo '
' . $row['Categorie'] . '
';
}
echo '' . $row['Titel'] . '
';
echo $row['Omschrijving'] . '
';
echo '' . $row['URL'] . '
';
}
break;
}
closeDB();
include('include/bottom.php');
?>