" WHERE gehalt <= 3000", 2 => " WHERE gehalt > 3000 AND gehalt <= 3500", 3 => " WHERE gehalt > 3500 AND gehalt <= 5000", 4 => " WHERE gehalt > 5000", default => "" }; $res = $con->query($sql); if($res->num_rows == 0) echo "Keine Ergebnisse"; while ($dsatz = $res->fetch_assoc()) echo $dsatz["name"] . ", " . $dsatz["gehalt"] . "
"; $res->close(); $con->close(); ?>