$wynik = dbquery("SELECT * FROM (

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

UNION ALL

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

UNION ALL

SELECT photo_id, photo_title, album_id, photo_thumb1, NAME_CONST('galery_id', 3) FROM ".fusion_photos3." 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']."/" : "");

        $url = "photogallery.php";

        break;

    case 2:

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

        $url = "photogallery2.php";

        break;

    case 3:

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

        $url = "photogallery3.php";

        break;

}









echo "<td align='center'>





<a href='".BASEDIR.$url."?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();