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

Поднимаю тему

Вот у меня вывод последних файлов

<?php
$i = 0;
$query = "SELECT * FROM files ORDER BY id DESC LIMIT 10";
$result = mysqli_query($db, $query);
while ($row = mysqli_fetch_array($result)) {
?>
    <div class="menu">
    <img src="screens/<?= $row['id'] ?>_mini.jpg" class="screen" alt=""/> <a href="track.php?id=<?= $row['id'] ?>"><?= $row['name'] ?></a><br/>
    <span><a href="category.php?select=artist&name=<?= base64_encode($row['artist']) ?>"><?= $row['artist'] ?></a></span>
    </div>
<?php
    $i++;  
}
if (empty($i)) {
    ?>
    <div class="menu">
        <?= lang('no_files') ?>
    </div>
    <?php    
}
?>