Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'yla.php'; ?>
- <div id="cont_top"></div>
- <div id="content">
- <div id="left"> <?php
- include 'avaa.php';
- include 'uuskaus.php';
- $kausi = $_GET['kausi'];
- $kysely = "SELECT id, nimi, ottelut, voitot, tasurit, tappiot, pisteet, tm, pm FROM joukkueet WHERE kausi = '$nykkaus' ORDER BY pisteet DESC, (tm-pm) DESC";
- $tulos = mysql_query($kysely);
- echo "<table width=100%><tr><td><b>#</b></td><td><b>Joukkue</b></td><td><b>Ottelut</b></td><td><b>Voitot</b></td><td><b>Tasurit</b></td><td><b>Häviöt</b></td><td><b>Pisteet</b></td><td><b>TM</b></td><td><b>PM</b></td><td><b>+/-</b></td></tr>";
- for ($i = 0; $i < mysql_num_rows($tulos); $i++) {
- $id = mysql_result($tulos, $i, "id");
- $sijoitus = $i + 1;
- $joukkue = mysql_result($tulos, $i, "nimi");
- $ottelut = mysql_result($tulos, $i, "ottelut");
- $voitot = mysql_result($tulos, $i, "voitot");
- $tasurit = mysql_result($tulos, $i, "tasurit");
- $tappiot = mysql_result($tulos, $i, "tappiot");
- $pisteet = mysql_result($tulos, $i, "pisteet");
- $tm = mysql_result($tulos, $i, "tm");
- $pm = mysql_result($tulos, $i, "pm");
- $maaliero = $tm - $pm;
- if ($i % 2 == 0) $vari = "white";
- else $vari = "lightblue";
- ?>
- <tr bgcolor=<?echo $vari ?>><td><?echo $sijoitus ?></td><td><a href="teams.php?id=<?echo $id ?>"><?echo $joukkue ?></a></td><td><?echo $ottelut ?></td><td><?echo $voitot ?></td><td><?echo $tasurit ?></td><td><?echo $tappiot ?></td><td><?echo $pisteet ?></td><td><?echo $tm ?></td><td><?echo $pm ?></td><td>
- <?php
- if ($maaliero >= 0) {
- echo "+";
- }
- echo $maaliero;
- ?></td></tr>
- <?php
- }
- echo "</table>"; ?>
- <div class="read"></div><br />
- </div><?php
- include 'sulje.php';
- include 'ala.php';
- ?>
Add Comment
Please, Sign In to add comment