Просмотр поста

$c = mysql_result(mysql_query("SELECT COUNT(*) FROM (SELECT DISTINCT user_id FROM cms_album_files) a"), 0);
 $rand = mt_rand(0, ($c - 1));
 $row = mysql_fetch_assoc(mysql_query("SELECT * FROM cms_album_files GROUP BY user_id ORDER BY user_id DESC LIMIT " . ($c > 1 ? $rand : 0) . ", 1"));
 echo '<a href="'.$home.'/users/profile.php?user='.$row['user_id'].'"><img src="'.$home.'/files/users/album/'.$row['user_id'].'/'.$row['tmb_name'].'"/>'.$row['name'].'</a>';