query($sql); echo "Länge:
"; while($dsatz = $res->fetch_assoc()) echo $dsatz["laenge"] . ": " . $dsatz["hersteller"] . " " . $dsatz["typ"] . "
"; $res->close(); echo "
"; $sql = "SELECT hersteller, typ," . " LENGTH(CONCAT(hersteller, typ)) AS laenge" . " FROM fp HAVING laenge >= 20 ORDER BY laenge DESC"; $res = $con->query($sql); echo "Länge >= 20:
"; while($dsatz = $res->fetch_assoc()) echo $dsatz["hersteller"] . " " . $dsatz["typ"] . "
"; $res->close(); $con->close(); ?>