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

echo '<div class="phdr"><b>Последние фотографии</b></div><div class="list1">';
$limit_album = '3'; // количество
$req_album = mysql_query("SELECT `id`, `user_id`, `album_id`, `tmb_name` FROM `cms_album_files` ORDER BY `time` DESC LIMIT $limit_album ");
while ($res_album = mysql_fetch_array($req_album)){
echo '<a href="/users/album.php?act=show&amp;al=' . $res_album['album_id'] . '&amp;img=' . $res_album['id'] . '&amp;user=' . $res_album['user_id'] . '&amp;view"><img src="/files/users/album/' . $res_album['user_id'] . '/' . $res_album['tmb_name'] . '" /></a> ';
}
echo '</div>';