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

$i = 0;
$query = "SELECT * FROM files ORDER BY id DESC LIMIT 5";
$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<?= $row['id'] ?>.html"><?= $row['name'] ?></a><br/>
    <span><a href="category.php?select=artist&amp;name=<?= base64_encode($row['artist']) ?>"><?= $row['artist'] ?></a></span>
    </div>

<?php 

    $i++;  

}