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>' . $cars['name'] .'/'.   $cars['model'] .'/'.   $cars['color']);
        }
        ?>
        </ul>


    </body>

    </html>