$result = dbquery("SELECT * FROM ".$db_prefix."photo_albums ORDER BY album_id DESC LIMIT 4");

if (dbrows($result)) { 

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

		

$kolumn = 4; 



echo "<table border='1' cellspacing='0' cellpadding='5'>";



echo "<tr><td colspan='$kolumn'><b><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."'>".$data['album_title']."</a></b></td></tr>";



$result2 = dbquery("SELECT * FROM ".$db_prefix."photos WHERE album_id='".$data['album_id']."' ORDER BY photo_datestamp DESC LIMIT 12");

while ($data2 = dbarray($result2)) {

  if (++$licznik==1) echo "<tr>";

  echo "<td><a href='".BASEDIR."photogallery.php?photo_id=".$data2['photo_id']."'>

<img src='".IMAGES."photoalbum/album_".$data['album_id']."/".$data2['photo_thumb1']."' alt=''/></a></td>";

  if ($licznik==$kolumn) { echo "</tr>"; $licznik=0; }

}



$koniec=$kolumn-count($lista)%$kolumn;

if ($koniec<>$kolumn) {

for ($i=0;$i<$koniec;$i++) {

$licznik++;

echo "<td> </td>";

}

if ($licznik==$kolumn) echo "</tr>";

}

echo "</table>";

  



}					

}