openside("name");

$num_photos = 3;



function first_view($name){

  static $name1 = null;

  if($name1 != $name){

    $res = true;

  } else {

    $res = false;

  }

 

  $name1 = $name;

 return $res;

}





$result = dbquery("SELECT * FROM (SELECT album_title, album_id, album_datestamp, photo_id, photo_datestamp, photo_thumb1,

  IF( @prev <> album_id, @rownum := 1, @rownum := @rownum+1 ) AS rank, 

    @prev := album_id 

 FROM ".DB_PHOTOS." LEFT JOIN ".DB_PHOTO_ALBUMS." USING (album_id)

 JOIN (SELECT @rownum := NULL, @prev := 0) AS r

 ORDER BY album_id, photo_datestamp DESC 

 ) AS tmp 

  WHERE tmp.rank <= '".$num_photos."' AND photo_id IS NOT NULL");

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>".(first_view($data['album_title']) ? "<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='' style='border:0px' /></a></td></tr>";

  }

  echo "</table>";

}

closeside();