Переделать код)

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>';

echo '<div class="phdr"><b>Последние фотографии</b></div><div class="list1">';
$limit_album = '3'; // количество
$req_album = $db->query("SELECT `id`, `user_id`, `album_id`, `tmb_name` FROM `cms_album_files` ORDER BY `time` DESC LIMIT $limit_album ");
while ($res_album = $res_album->fetch()){
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>';

# PaRtiZzaN (23.02.2020 / 07:16)
Кеня, while ($res_album = $req_album->fetch())

Проипал букву))

# PaRtiZzaN (23.02.2020 / 07:58)
Кеня, а ты ссылку правильную поставь и заработает.

$req = $db->query("
      SELECT `cms_album_files`.*, `users`.`name` AS `user_name`, `cms_album_cat`.`name` AS `album_name` $select
      FROM `cms_album_files`
      LEFT JOIN `users` ON `cms_album_files`.`user_id` = `users`.`id`
      LEFT JOIN `cms_album_cat` ON `cms_album_files`.`album_id` = `cms_album_cat`.`id`
      $join
      ORDER BY `time` DESC LIMIT 3 
    ");

    for ($i = 0; $res = $req->fetch(); ++$i) {
        echo $i % 2 ? '<div class="list2">' : '<div class="list1">';
  echo '<a href="../album/index.php?act=show&amp;al=' . $res['album_id'] . '&amp;img=' . $res['id'] . '&amp;user=' . $res['user_id'] . '&amp;view"><img src="../files/users/album/' . $res['user_id'] . '/' . $res['tmb_name'] . '" /></a>';
        
    }