Талтос,
$lasfoto = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` ORDER BY `time` DESC LIMIT 1"), 0);
if ($lasfoto)
$photo = mysql_fetch_array($lastfoto);
echo ' <a href="'.$set['home'].'/users/profile.php?user='.$photo['id'].'"><img src="files/users/photo/' . $photo['id'] . '_small.jpg" alt="" /></a>';
так пробуй.