openside("name");

$result = dbquery(

"SELECT a.album_title, p.album_id

FROM ".DB_PHOTOS." p

LEFT JOIN ".DB_PHOTO_ALBUMS." a USING (album_id)

WHERE ".groupaccess('album_access')."

GROUP BY p.album_id ORDER BY MAX(p.photo_id) DESC

");

if(dbrows($result) > 0) {     

while($row = dbarray($result)){

echo THEME_BULLET.' <a href="'.BASEDIR.'photogallery.php?album_id='.$row['album_id'].'">'.$row['album_title'].'</a></br>';  

}

}else {



echo 'Brak danych do wyświetlenia w statystykach';

}

closeside();