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();