" WHERE preis <= 120",
2 => " WHERE preis > 120 AND preis <= 140",
3 => " WHERE preis > 140",
default => ""
};
if (isset($_POST["sortieren"]))
$sql .= " ORDER BY preis DESC";
$res = $con->query($sql);
if($res->num_rows == 0)
echo "Keine Ergebnisse";
while ($dsatz = $res->fetch_assoc())
echo $dsatz["hersteller"] . ", "
. $dsatz["typ"] . ", "
. $dsatz["preis"] . " €
";
$res->close();
$con->close();
?>