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

$album_rasmlari = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_album_files` WHERE `user_id` = '" . $user['id'] . "'"), 0);
echo '
<div class="phdr">Shaxsiy rasmlar ' . ($album_rasmlari ? $album_rasmlari : '') . '</div>
<div class="menu">';
    $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time`  DESC LIMIT 8");
    $fotosurat = mysql_fetch_array($fotoalbom); 

    if (file_exists('../files/users/album/' . $user['id'] . '/' . $fotosurat['img_name'] . '')) { 
        $fotoalbom = mysql_query("SELECT `id`, `user_id`, `album_id`, `img_name` FROM `cms_album_files` WHERE `user_id` = '" .$user['id']. "' ORDER BY `time`  DESC LIMIT 8");
        while ($fotosurat = mysql_fetch_array($fotoalbom)) {echo '
            <a href="../users/album.php?act=show&amp;al=' . $fotosurat['album_id'] . '&amp;img=' . $fotosurat['id'] . '&amp;user=' . $fotosurat['user_id'] . '&amp;view">
                <img style="height: 80px;" src="../files/users/album/' . $fotosurat['user_id'] . '/' . $fotosurat['img_name'] . '" />
            </a>'; 
        }
    } else {
        echo '<bold>' .$user['name']. '</bold> fotoalbomiga fotosuratlar qo\'shmagan!';
    } echo '
</div>'; //.menu