$result=dbquery(

"SELECT tp.*, ta.*[b], tu.user_name[/b] FROM ".$db_prefix."ug_photos tp

LEFT JOIN ".$db_prefix."ug_photo_albums ta USING(album_id)

[b]LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id[/b] 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='".BASEDIR."profile.php?lookup=".$data['user_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='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".trimlink($data['user_name'], 17)."</a></td>";

}

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

}

closetable();