| Nr zamówienia |
Nazwisko |
Imię |
Kolor |
Pojemność [ml] |
Data odbioru |
= '$dataod' AND data_odbioru <= '$datado' ORDER BY data_odbioru;";
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
echo "";
echo "| " . $row["id"] . " | ";
echo "" . $row["nazwisko"] . " | ";
echo "" . $row["imie"] . " | ";
echo "" . $row["kod_koloru"] . " | ";
echo "" . $row["pojemnosc"] . " | ";
echo "" . $row["data_odbioru"] . " | ";
echo "
";
}
}
else {
$sql = "SELECT nazwisko, imie, zamowienia.id, kod_koloru, pojemnosc, data_odbioru FROM klienci JOIN zamowienia ON klienci.id = id_klienta ORDER BY data_odbioru;";
$result = $conn->query($sql);
while ($row = $result->fetch_assoc()) {
echo "";
echo "| " . $row["id"] . " | ";
echo "" . $row["nazwisko"] . " | ";
echo "" . $row["imie"] . " | ";
echo "" . $row["kod_koloru"] . " | ";
echo "" . $row["pojemnosc"] . " | ";
echo "" . $row["data_odbioru"] . " | ";
echo "
";
}
}
$conn -> close();
?>
