$result=dbquery(

"SELECT ta.album_id,album_title,photo_id,photo_title FROM ".$db_prefix."photo_albums ta ".

"JOIN ".$db_prefix."photos USING (album_id) [color=green][b]WHERE ta.album_id='[i]x[/i]'[/b][/color] ORDER BY RAND() LIMIT 1"

);



if (dbrows($result) == 1) {

@openside($locale['FOT_001']);

$data=dbarray($result);

$filename=PHOTOS.$data['photo_id'].'t.jpg';

if (!file_exists($filename)) $filename=$image_url.'/imagenotfound.jpg';

echo "<div style='text-align:center'>

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

<img src='".PHOTOS."".$data['photo_id']."t.jpg' width='".$settings['thumb_image_w']."' height='".$settings['thumb_image_h']."'

title='".$data['photo_title']."' alt='".$data['photo_title']."'>

</a><br /><a href='".BASEDIR."photogallery.php?album=".$data['album_id']."'>".$data['photo_title']."</a>