$result = dbquery(

"SELECT tp.photo_id, tp.photo_title, tp.photo_thumb1, ta.album_id, ta.album_title FROM ".DB_PHOTOS." tp

LEFT JOIN ".DB_PHOTO_ALBUMS." ta USING(album_id)

WHERE ".groupaccess('album_access')." ORDER BY RAND() LIMIT 1"

);

if (dbrows($result)) {

   $data = dbarray($result);



   define("R_SAFEMODE", @ini_get("safe_mode") ? true : false);

   define("R_PHOTODIR", PHOTOS.(!R_SAFEMODE ? "album_".$data['album_id']."/" : ""));



   echo "<div align='center'>\n";

   echo "<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='photogallery_album_photo_link'>\n";

   if ($data['photo_thumb1'] && file_exists(R_PHOTODIR.$data['photo_thumb1'])) {

      echo "<img src='".R_PHOTODIR.$data['photo_thumb1']."' alt='".$data['photo_title']."' style='border:0px' class='photogallery_album_photo' />\n";

   } else {

      echo "<img src='".IMAGES."imagenotfound.jpg' alt='".$data['photo_title']."' style='border:0px' class='photogallery_album_photo' />\n";

   }

   echo "</a>\n";

   echo "<br />\n";

   echo "<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' class='side'><strong>".$data['photo_title']."</strong></a>\n";

   echo "<br />\n";

   echo "<a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."' class='side'>".$data['album_title']."</a>\n";

   echo "</div>\n";