Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!doctype html>
- <head>
- <title>Choroszcz</title>
- <head>
- <body>
- <?php
- $b= mysqli_connect('localhost', 'root', '','yeet3');
- $zap = mysqli_query($b,"SELECT Min(cena),nazwa FROM dania WHERE typ=2");
- $zap2 = mysqli_query($b,"SELECT id,nazwa,cena FROM dania WHERE typ=3");
- $zap3 = mysqli_query($b,"SELECT id,nazwa,cena FROM dania WHERE typ=4");
- while($row = mysqli_fetch_array($zap)) {
- echo $row["nazwa"]." cena:".$row["Min(cena)"];
- }
- echo "<hr>";
- while($row2 = mysqli_fetch_array($zap2)){
- echo "<p>id:".$row2["id"]."</p><p>nazwa:".$row2["nazwa"]."</p><p>cena:".$row2["cena"]."zł</p><br>";
- }
- echo "<hr>";
- while($row3 = mysqli_fetch_array($zap3)){
- echo "<p>id:".$row3["id"]."</p><p>nazwa:".$row3["nazwa"]."</p><p>cena:".$row3["cena"]."zł</p><br>";
- }
- mysqli_close($b);
- ?>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement