Fotogalerij
echo getPage("GALERIJ","NL",$con);
echo "
";
$links="";
$SQL="select * from tbl_album order by Alb_Id desc;";
$q_table=mysqli_query($con,$SQL);
if(mysqli_num_rows($q_table)>0){
while($r_table=mysqli_fetch_object($q_table)){
$SQL="select * from tbl_albumafbeelding where Keyvalue=$r_table->Alb_Id order by Sort";
$q_afbeelding=mysqli_query($con,$SQL);
if(mysqli_num_rows($q_afbeelding)>0){
$first=1;
while($r_afbeelding=mysqli_fetch_object($q_afbeelding)){
if($first==1){
echo "
\n";
$first=0;
}else{
$links.= "
image2\" data-fancybox=\"galerij_$r_table->Alb_Id\" data-thumb=\"$r_afbeelding->image1\">\n";
}
}
}
}
echo "
";
echo $links;
echo "