if($row['history'] == "1"){
$gallery_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$row['id']."' ORDER BY date ASC");
$gallery2_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$row['id']."' ORDER BY date ASC");
}else{
$gallery_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$row['id']."' ORDER BY id ASC");
$gallery2_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$row['id']."' ORDER BY id ASC");
}
$gallery_count = mysql_num_rows($gallery_sql);
?>
Bekijk hieronder alle echo $gallery_count; ?> foto's if(!empty($row['author'])){ ?>gemaakt door echo $row['author']; } ?> van bovengenoemde activiteit op echo strtolower(dutchdate($row['timestamp'])); ?>.
if($album_counter == TRUE){
$per_page =10;//define how many games for a page
$query_count = mysql_query("SELECT * FROM site_media_galleries WHERE listed='1'");
$count = mysql_num_rows($query_count);
$pages = ceil($count/$per_page);
if(empty($_GET['page'])){
$page="1";
$pageplus = $page+1;
$pageplustwo = $page+2;
$pagemin = $page-1;
}else{
$page=$_GET['page'];
$pageplus = $page+1;
$pageplustwo = $page+2;
$pagemin = $page-1;
}
$start = ($page - 1) * $per_page;
$news_sql = mysql_query("SELECT * FROM site_media_galleries WHERE listed='1' ORDER BY timestamp DESC LIMIT $start,$per_page");
}else{
$news_sql = mysql_query("SELECT * FROM site_media_galleries WHERE listed='1' ORDER BY timestamp DESC LIMIT 10");
}
$news_check = mysql_num_rows($news_sql);
$counter = '0';
?>
if($news_check == TRUE){ ?>
while($news = mysql_fetch_assoc($news_sql)){
$thumb_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$news['id']."' ORDER BY id ASC LIMIT 1") or die (mysql_error());
$thumb = mysql_fetch_assoc($thumb_sql);
$gallery_count_sql = mysql_query("SELECT * FROM site_media WHERE gallery='".$news['id']."'") or die (mysql_error());
$gallery_count = mysql_num_rows($gallery_count_sql);
?>