= '2008-01-01' AND prod < '2008-07-01'" . " ORDER BY prod"; $res = $con->query($sql); if($res->num_rows == 0) echo "Keine Ergebnisse"; while ($dsatz = $res->fetch_assoc()) echo $dsatz["hersteller"] . ", " . $dsatz["typ"] . ", " . $dsatz["prod"] . ", " . $dsatz["artnummer"] . "
"; $res->close(); $con->close(); ?>