Untitled
Guest 689 15th Nov, 2019
<?php
$baza=mysqli_connect("localhost","root","","sportowcy");
$wynik=mysqli_query($baza,"SELECT COUNT(id) FROM sportowiec;");
$xdd=mysqli_fetch_row($wynik);
$xd=$xdd[0]/2;
$j=1;
for($i=0;$i<$xd;$i++)
{
$x=$j+2;
print "<tr>";
for($j;$j<$x;$j++)
{
$hehe=mysqli_query($baza,"SELECT imie,nazwisko FROM sportowiec WHERE id=$j");
$heh=mysqli_fetch_row($hehe);
$hehe2=mysqli_query($baza,"SELECT AVG(wynik) FROM wyniki WHERE sportowiec_id=$j AND dyscyplina_id=3;");
$heh2=mysqli_fetch_array($hehe2);
print ("<td><h3>".$heh[0]." ".$heh[1]."</h3><p>średni wynik ".$heh2[0]."</p></td>");
}
print "</tr>";
}
?>
To share this paste please copy this url and send to your friends
RAW Paste Data
Recent Pastes
- Untitled
Markup | 19 | 10 hours ago
- Untitled
Markup | 24 | 13 hours ago
- Wanted to see what your conviction is on this theme
Markdown | 14 | 14 hours ago
- Untitled
Markup | 65 | 1 day ago
- mega555kf7lsmb54yd6etzginolhxxi4ytdoma2rf77ngq55fhfcnyid.onion
Template Toolkit 2 | 25 | 1 day ago
- Untitled
Markup | 70 | 2 days ago
- Untitled
Markup | 77 | 2 days ago