Advertisement
Guest User

Untitled

a guest
Feb 21st, 2018
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. if($select=='Option 1')
  2. {
  3. echo "Risultato della query selezionata:SELECT DISTINCT Nome FROM Sale WHERE Citta = 'Pisa'";
  4. echo "<hr>";
  5. $query = "SELECT DISTINCT Nome FROM Sale WHERE Citta = 'Pisa'";
  6. $result = mysqli_query($connect, $query)
  7. or die ("Errore nella query" . mysqli_error($connect));
  8.  
  9. echo "<table>";
  10. echo "<tr>";
  11. echo "<th>"."Nome Sala"."</th>";
  12. echo "</tr>";
  13. while ($search = mysqli_fetch_array($result))
  14. {
  15. echo "<tr>";
  16. echo "<td> "."$search[Nome] "."</td>";
  17. echo "</tr>";
  18. }
  19. echo "</table>";
  20. // libero la memoria occupata dall'istruzione SELECT
  21. mysqli_free_result($result);
  22. mysqli_close($connect);
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement