Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $polaczenie = mysqli_connect("localhost", "root", "", "p1");
- $zapytanie1 = mysqli_query($polaczenie, "SELECT `nazwa`, MIN(`cena`) FROM `dania` WHERE typ = 2 ");
- while ($row = mysqli_fetch_array ($zapytanie1))
- {
- echo $row['0'].", Cena: ".$row['1']."<p>";
- }
- ?>
- <br>
- <?php
- $zapytanie1 = mysqli_query($polaczenie, "SELECT `id`, `nazwa`, `cena` FROM `dania` WHERE typ = 3");
- while ($row = mysqli_fetch_array ($zapytanie1))
- {
- echo $row['0'].", ".$row['1'].", ".$row['1']."<p>";
- }
- ?>
- <br>
- <?php
- $zapytanie1 = mysqli_query($polaczenie, "SELECT `id`, `nazwa`, `cena` FROM `dania` WHERE typ = 4");
- while ($row = mysqli_fetch_array ($zapytanie1))
- {
- echo $row['0'].", ".$row['1'].", ".$row['2']."<p>";
- }
- ?>
- <?php
- mysqli_close($polaczenie);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement