Untitled

<?php require('connect.php'); ?>
< <!DOCTYPE>
    <html>

    <head>

    </head>

    <body>
        <h1>Popis</h1>
        <?php
                $sql = "SELECT brands.name,cars.id,cars.model,cars.color,cars.mileage FROM brands, cars WHERE brands.id = cars.brand_id";
                $result = $mysqli->query($sql);
            ?>
        <ul>
        <?php

        while ($cars = $result->fetch_assoc()) {

        echo('<li> <a href = "proizvodaci.php?id=' . $cars['id'] . '">' . $cars['name'] . '</a> / ' . $cars['model'] . ' / ' . $cars['color'] . '</li>');

        }

        ?>
        </ul>


    </body>

    </html>