Advertisement
Guest User

Untitled

a guest
Mar 18th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. $idtor = (int)$_GET['id_tor'];
  2. $consul = "SELECT id_cantos, id_torneio, id_campeonato, SUM(cantosfim) AS cantfin, SUM(pontos) AS pontfin FROM cantos INNER JOIN campeonato ON id_camp = id_campeonato INNER JOIN torneio ON id_tor = id_torneio WHERE id_tor = :idtor GROUP BY anilha ORDER BY pontfin DESC, cantfin DESC";
  3. $stmt = $pdo->prepare($consul);
  4. $stmt->bindParam(':idtor', $idtor);
  5. $stmt->execute();
  6. while ($lin = $stmt->fetch(PDO::FETCH_ASSOC)) {
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement