Wyświetl dane z MYSQL; Błąd instrukcji SQL
Mam formularz .. chce wyświetlić dane z tabeli mysql .. problem polega na tym, że instrukcja zapytania SQL nie wyświetla danych .. wszystkie pomysły? Myślę, że błąd może wynikać z instrukcji AND w linii zapytania SQL?
<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>