Daten von MYSQL anzeigen; SQL-Anweisungsfehler
Ich habe ein Formular .. möchte die Daten aus der MySQL-Tabelle anzeigen .. Problem ist, dass die SQL-Abfrageanweisung die Daten nicht anzeigt .. irgendwelche Ideen? Ich denke, der Fehler kann auf die AND-Anweisung in der SQL-Abfragezeile zurückzuführen sein.
<code> <form method="get" action="submit.php"> Number of Bedrooms: <select name="bedrooms"> <option selected value='#'>--Choose Number of Bedrooms--</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> Number of Occupants: <select name="sleeps_min"> <option selected value='#'>--Choose Number of Bedrooms--</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> </select> Availability: <select name="availability"> <option selected value='#'>--Select Availability Period--</option> <option value="All year round">All Year Round</option> <option value="New Year Availability Only">New Year</option> </select> <input type="submit" value="submit" /> </form> </code>
-
<code> require 'defaults.php'; require 'database.php'; /* get properties from database */ $property = $_GET['bedrooms'] ; $sleeps_min = $_GET['sleeps_min'] ; $availability = $_GET['availability'] ; $query = "SELECT * FROM `properties` WHERE bedrooms = '{$bedrooms}' sleeps_min = '{$sleeps_min}' AND availability = '{$availability}'"; $row=mysql_query($query); $result = do_query("SELECT * FROM `properties` WHERE bedrooms = '{$bedrooms}' sleeps_min = '{$sleeps_min}' AND availability = '{$availability}'", $db_connection); while ($row = mysql_fetch_assoc($result)) { $r[] = $row; } ?> </code>