$fqyl = "SELECT Marka, Model, Rocznik FROM auta2 WHERE Kolor = 'czarna perła' ORDER BY Rocznik DESC"; $wynik = mysqli_query($link, $sql); echo "zad1"; echo ""; while($row = mysqli_fetch_array($result)){ if ($row['Rocznik']>2012) { echo ""; echo ""; echo ""; echo ""; } } echo "
" . $row['Marka'] . "" . $row['Model'] . "
"; mysqli_free_result($result); $fqyl = "SELECT Kolor, Rocznik FROM auta2"; $wynik = mysqli_query($link, $sql); echo "
zad2
"; echo ""; while($row = mysqli_fetch_array($result)){ if ($row['Rocznik']>=2009) { echo ""; echo ""; echo ""; } } echo "
" . $row['Kolor'] . "
"; mysqli_free_result($result); $fqyl = "SELECT * FROM auta2 ORDER BY Rocznik"; $wynik = mysqli_query($link, $sql); echo "
zad3
"; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; $i = 0; foreach ($row as $key) { $i++; if($i<6){ echo "";} } echo ""; } echo "
" . $row[$i] . "
"; $fqyl = "SELECT Marka, Model, Ilosc_drzwi FROM auta2 WHERE Kolor = 'Czarny' ORDER BY Marka DESC"; $wynik = mysqli_query($link, $sql); echo "
zad4
"; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
" . $row['Marka'] . "" . $row['Model'] . "" . $row['Ilosc_drzwi'] . "
"; mysqli_free_result($result);