$result=dbquery(

"SELECT tp.*, ta.* FROM ".$db_prefix."ug_photos tp

LEFT JOIN ".$db_prefix."ug_photo_albums ta USING(album_id) ORDER BY RAND() LIMIT 4"

);

if(dbrows($result)>0){

opentable("Losowe Fotki Userów");

echo "<table align='center' cellpadding='5' cellspacing='5' width=100><tr>";

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

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

echo "<td align='center'>

<a href='".INFUSIONS."usergalerie/view_usergalerie.php?photo=".$data['photo_id']."' class='gallery'>

<img src='".USERGALERIE."".$data['photo_id']."t.jpg' title='".$data['photo_title']."' alt='".$data['photo_title']."' border='0' height=90 width=115>

</a><br>

<a href='".INFUSIONS."usergalerie/view_usergalerie.php?photo=".$data['photo_id']."' class='side'>".trimlink($data['photo_title'], 17)."</a></td>";

}

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