daily pastebin goal
60%
SHARE
TWEET

Untitled

a guest Mar 18th, 2019 47 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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)) {
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top