$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 "" . $row['Marka'] . " | ";
echo "" . $row['Model'] . " | ";
echo "
";
}
}
echo "
";
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 "" . $row['Kolor'] . " | ";
echo "
";
}
}
echo "
";
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 "" . $row[$i] . " | ";}
}
echo "
";
}
echo "
";
$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 "" . $row['Marka'] . " | ";
echo "" . $row['Model'] . " | ";
echo "" . $row['Ilosc_drzwi'] . " | ";
echo "
";
}
echo "
";
mysqli_free_result($result);