connect_error) { die("Połączenie nieudane: " . $conn->connect_error); } $sql = "SELECT * FROM auta5 WHERE Kolor='Biały' order by Marka"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "id: " . $row["id"] . "
" . "Marka: " . $row["Marka"] . "
" . "Model: " . $row["Model"] . "
" . "Ilość drzwi: " . $row["Ilosc_drzwi"] . "
" . "Rocznik: " . $row["Rocznik"] . "
" . " Kolor: " . $row["Kolor"] . "
" ; } } else { } echo "liczba wyświetlonych rekordów: " ; echo $result->num_rows; $conn->close();