Advertisement
Guest User

Dis to skurwysyn

a guest
Feb 24th, 2020
182
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. <?php
  2. $polaczenie = mysqli_connect("localhost", "root", "", "p1");
  3. $zapytanie1 = mysqli_query($polaczenie, "SELECT `nazwa`, MIN(`cena`) FROM `dania` WHERE typ = 2 ");
  4. while ($row = mysqli_fetch_array ($zapytanie1))
  5. {
  6. echo $row['0'].", Cena: ".$row['1']."<p>";
  7. }
  8. ?>
  9. <br>
  10. <?php
  11. $zapytanie1 = mysqli_query($polaczenie, "SELECT `id`, `nazwa`, `cena` FROM `dania` WHERE typ = 3");
  12. while ($row = mysqli_fetch_array ($zapytanie1))
  13. {
  14. echo $row['0'].", ".$row['1'].", ".$row['1']."<p>";
  15. }
  16. ?>
  17. <br>
  18. <?php
  19. $zapytanie1 = mysqli_query($polaczenie, "SELECT `id`, `nazwa`, `cena` FROM `dania` WHERE typ = 4");
  20. while ($row = mysqli_fetch_array ($zapytanie1))
  21. {
  22. echo $row['0'].", ".$row['1'].", ".$row['2']."<p>";
  23. }
  24. ?>
  25. <?php
  26. mysqli_close($polaczenie);
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement