$wynik = dbquery("SELECT * FROM (

SELECT photo_id, photo_title, album_id, photo_thumb1, NAME_CONST('galery_id', 1) FROM ".DB_PHOTOS." WHERE ".groupaccess('album_access')."

UNION ALL 

SELECT photo_id, photo_title, album_id, photo_thumb1, NAME_CONST('galery_id', 2) FROM ".DB_PHOTOS1." WHERE ".groupaccess('album_access')."

UNION ALL 

SELECT photo_id, photo_title, album_id, photo_thumb1, NAME_CONST('galery_id', 3) FROM ".DB_PHOTOS2." WHERE ".groupaccess('album_access')."

) AS tabela ORDER BY RAND() LIMIT 7");

opentable("Zdjêcia");

if(dbrows($wynik) > 0) { 



echo "<marquee behavior='scroll' align='center' valign='bottom' direction='left' scrollamount='2' scrolldelay='1' onmouseover='this.stop()' onmouseout='this.start()'>





<table align='center' cellpadding='0' cellspacing='0'><tr>";



while($data = dbarray($wynik))    

{ 



switch ($data['galery_id']) {

    case 1:

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

        break;

    case 2:

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

        break;

    case 3:

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

        break;

}









echo "<td align='center'>





<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='gallery'>





<img src='".$randphotodir.$data['photo_thumb1']."' title='".$data['photo_title']."' alt='".$data['photo_title']."' border='0' width='100px' height='70px' />





</a><br />





</td>";



}

echo "</tr></table></marquee>";

}

closetable();