query("SELECT * FROM site_news_folders WHERE slug='".$_GET['slug']."' AND regio='".$siteregio."'");
$cat_check = mysqli_num_rows($cat_sql);
if($cat_check == TRUE){
$cat = mysqli_fetch_assoc($cat_sql);
$search_sql = mysql_query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3'");
$search_check = mysql_num_rows($search_sql);
}else{
header("location: /dossiers/");
}
}
?>
query("SELECT * FROM site_news_folders WHERE slug='".$_GET['slug']."' AND regio='".$siteregio."'");
$cat_check = mysqli_num_rows($cat_sql);
if($cat_check == TRUE){
$cat = $cat_sql -> fetch_assoc();
$query_count = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC");
}else{
$query_count = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC");
}
}else{
$query_count = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC");
}
$count = mysqli_num_rows($query_count);
$pages = ceil($count/$per_page);
if(empty($_GET['page'])){
$page="1";
$pageplus = $page+1;
}else{
$page=$_GET['page'];
$pageplus = $page+1;
}
$start = ($page - 1) * $per_page;
if($_GET['cat']){
$cat_sql = $mysqli -> query("SELECT * FROM site_news_folders WHERE slug='".$_GET['slug']."' AND regio='".$siteregio."'");
$cat_check = mysqli_num_rows($cat_sql);
if($cat_check == TRUE){
$cat = $cat_sql -> fetch_assoc();
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT $start,$per_page");
}else{
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT $start,$per_page");
}
}else{
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT $start,$per_page");
}
}else{
if($_GET['cat']){
$cat_sql = $mysqli -> query("SELECT * FROM site_news_folders WHERE slug='".$_GET['slug']."' AND regio='".$siteregio."'");
$cat_check = mysqli_num_rows($cat_sql);
if($cat_check == TRUE){
$cat = $cat_sql -> fetch_assoc();
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT 10");
}else{
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT 10");
}
}else{
$news_sql = $mysqli -> query("SELECT * FROM site_news WHERE folder='".$cat['id']."' AND regio='".$siteregio."' AND status='3' ORDER BY last_update DESC LIMIT 10");
}
}
$news_check = mysqli_num_rows($news_sql);
$counter = '0';
?>
1){
if($cat_check == TRUE){
$catname = $cat['slug'];
echo handle_pagination($search_check, 10, $page, '/'.$catname.'/?page=%d');
}else{
echo handle_pagination($search_check, 10, $page, '/nieuws/?page=%d');
}
} ?>
Er zijn geen artikelen gevonden. Klik hier om de voorpagina te bezoeken.
";
?>
Dossier:
query("SELECT * FROM site_news_categories WHERE id='".$news['category']."'");
$cat = $cat_sql -> fetch_assoc(); ?>
Dossiers
query("SELECT * FROM site_news WHERE folder='".$news['id']."'");
$cat = mysqli_num_rows($cat_sql); ?>