$result = dbquery("SELECT a.*, p.*, a.album_title, a.album_thumb, a.album_datestamp, p.album_id, p.photo_id, p.photo_thumb1

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 LIMIT 0,3");



if(dbrows($result)>0){



echo "<table align='center' cellpadding='0' cellspacing='0' width='100%'>";





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

$randphotodir = PHOTOS.(!@ini_get("safe_mode") ? "album_".$data['album_id']."/" : "");



echo "<tr><td><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."'>".$data['album_title']."</a> <span style='color: #C6C6C6; font-size: 10px;'>Dodane: ".showdate("shortdate", $data['album_datestamp'])."</span><br><a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."'><img src='".$randphotodir.$data['photo_thumb1']."' alt='".$data['photo_thumb1']."' title='".$locale['431']."' style='border:0px' /></a></td></tr>";

}

echo "</table>";



}