NUFC.com.pl | Newcastle United

Strona główna

Newcastle United

Informacje Sztab St. James' Park Sukcesy Rekordy Miasto

Sezon 2024/25

Kadra Terminarz Tabela Statystki U-21 U-18 NUWFC

Historia

Historia klubu Pierwszy mecz Kapitanowie

Toon Army

Shoutbox Twitter Wideo

NUFC.com.pl

Kontakt Reklama Archiwum

☰

Rywale Srok

Klikając na dany klub otrzymasz więcej informacji!

"; $klub = mysql_query("SELECT id FROM klub WHERE id != 1 ORDER by nazwa"); if(mysql_num_rows($klub) > 0) { while($k= mysql_fetch_assoc($klub)) { $tabela = mysql_query("SELECT m.*, k.nazwa zespol, k.nazwa, k.id kid, SUM( ( @remis := IF ( ( m.gol1 = m.gol2 ) AND ((m.team1 = ".$k['id']." and m.team2 = 1) OR (m.team2 = ".$k['id']." and m.team1 = 1)), 1, 0 ) ) + ( @zwyciestwo := IF ( ( m.gol1 > m.gol2 AND m.team1 = 1 and m.team2 = ".$k['id'].") OR ( m.gol1 < m.gol2 AND m.team2 = 1 and m.team1 = ".$k['id']." ), 1, 0 ) ) * 3) AS punkty, SUM( IF ( m.team1 = 1 OR m.team2 = 1, 1, 0 ) ) AS mecze, SUM( @zwyciestwo ) AS zwyciestwa, SUM( @remis ) AS remisy, SUM( IF ( ( m.gol1 < m.gol2 AND m.team1 = 1 and m.team2 = ".$k['id'].") OR ( m.gol1 > m.gol2 AND m.team2 = 1 and m.team1 = ".$k['id']." ), 1, 0 ) ) AS przegrane, SUM( @brz := IF ( m.team1 = k.id, m.gol2, m.gol1 ) ) AS bramkizdobyte, SUM( @brs := IF ( m.team1 = k.id, m.gol1, m.gol2 ) ) AS bramkistracone, SUM( @brz - @brs ) AS roznicabramek FROM mecz_nufc AS m, klub AS k WHERE ( m.team1 = ".$k['id']." OR m.team2 = ".$k['id']." ) AND ( gol1 IS NOT NULL ) and k.id = ".$k['id']." and m.rozgrywki != 18 GROUP BY k.nazwa") or die('Błąd zapytania: '.mysql_error()); if(mysql_num_rows($tabela) > 0) { while($r= mysql_fetch_assoc($tabela)) { if ($r['kid'] == $id) echo ""; else echo ""; echo ""; if ($r[roznicabramek] > 0) echo ""; else echo ""; echo ""; }} }} echo "

	NEWCASTLE VS	MR	Z	R	P	BRAMKI			RB
	".$r['zespol']."	".$r['mecze']."	".$r['zwyciestwa']."	".$r['remisy']."	".$r['przegrane']."	".$r['bramkizdobyte']."	:	".$r['bramkistracone']."	+".$r['roznicabramek']."	".$r['roznicabramek']."

"; echo "

"; $klub = mysql_query("SELECT nazwa FROM klub WHERE id = $id"); if(mysql_num_rows($klub) > 0) { while($k= mysql_fetch_assoc($klub)) { echo "

NUFC vs ".$k['nazwa']."

"; }} echo ""; $tabela = mysql_query("SELECT DISTINCT m.*, k.short zespol, k.nazwa, k.id kid, SUM( ( @remish := IF ( ( m.gol1 = m.gol2 ) AND (m.team1 = 1 and m.team2 = $id and m.neutral=0), 1, 0 ) ) + ( @zwyh := IF ( ( m.gol1 > m.gol2 AND m.team1 = 1 and m.team2 = $id and m.neutral=0), 1, 0 ) ) * 3) AS punkty, SUM( IF ( m.team1 = 1 and m.team2 = $id and m.neutral=0, 1, 0 ) ) AS meczh, SUM( @zwyh ) AS wygh, SUM( @remish ) AS remh, SUM( IF ( ( m.gol1 < m.gol2 AND m.team1 = 1 and m.team2 = $id and m.neutral=0), 1, 0 ) ) AS przegh, SUM( ( @remisa := IF ( ( m.gol1 = m.gol2 ) AND (m.team2 = 1 and m.team1 = $id and m.neutral=0), 1, 0 ) ) + ( @zwya := IF ( ( m.gol1 < m.gol2 AND m.team2 = 1 and m.team1 = $id and m.neutral=0), 1, 0 ) ) * 3) AS punkty, SUM( IF ( m.team2 = 1 and m.team1 = $id and m.neutral=0, 1, 0 ) ) AS mecza, SUM( @zwya ) AS wyga, SUM( @remisa ) AS rema, SUM( IF ( ( m.gol1 > m.gol2 AND m.team2 = 1 and m.team1 = $id and m.neutral=0), 1, 0 ) ) AS przega, SUM( ( @remisn := IF ( ( m.gol1 = m.gol2 ) and m.neutral=1 AND ((m.team1 = $id and m.team2 = 1) OR (m.team2 = $id and m.team1 = 1)), 1, 0 ) ) + ( @zwyciestwon := IF ( ( m.gol1 > m.gol2 AND m.team1 = 1 and m.team2 = $id and m.neutral=1) OR ( m.gol1 < m.gol2 AND m.team2 = 1 and m.team1 = $id and m.neutral=1), 1, 0 ) ) * 3) AS punkty, SUM( IF ( (m.team1 = 1 OR m.team2 = 1) and m.neutral=1, 1, 0 ) ) AS meczen, SUM( @zwyciestwon ) AS zwyciestwan, SUM( @remisn ) AS remisyn, SUM( IF ( ( m.gol1 < m.gol2 AND m.team1 = 1 and m.team2 = $id and m.neutral=1) OR ( m.gol1 > m.gol2 AND m.team2 = 1 and m.team1 = $id and m.neutral=1), 1, 0 ) ) AS przegranen, SUM( ( @remis := IF ( ( m.gol1 = m.gol2 ) AND ((m.team1 = $id and m.team2 = 1) OR (m.team2 = $id and m.team1 = 1)), 1, 0 ) ) + ( @zwyciestwo := IF ( ( m.gol1 > m.gol2 AND m.team1 = 1 and m.team2 = $id) OR ( m.gol1 < m.gol2 AND m.team2 = 1 and m.team1 = $id ), 1, 0 ) ) * 3) AS punkty, SUM( IF ( m.team1 = 1 OR m.team2 = 1, 1, 0 ) ) AS mecze, SUM( @zwyciestwo ) AS zwyciestwa, SUM( @remis ) AS remisy, SUM( IF ( ( m.gol1 < m.gol2 AND m.team1 = 1 and m.team2 = $id) OR ( m.gol1 > m.gol2 AND m.team2 = 1 and m.team1 = $id ), 1, 0 ) ) AS przegrane, SUM( @brzh := IF ( (m.team1 = 1 and m.neutral = 0), m.gol1, 0 ) ) AS bzhome, SUM( @bzn1 := IF ( (m.team1 = 1 and m.neutral = 1), m.gol1, 0 ) ) AS bzn1, SUM( @bzn2 := IF ( (m.team2 = 1 and m.neutral = 1), m.gol2, 0 ) ) AS bzn2, SUM( @brza := IF ( (m.team2 = 1 and m.neutral = 0), m.gol2, 0 ) ) AS bzaway, SUM( @brsa := IF ( (m.team2 = 1 and m.neutral = 0), m.gol1, 0 ) ) AS bsaway, SUM( @brsh := IF ( (m.team1 = 1 and m.neutral = 0), m.gol2, 0 ) ) AS bshome, SUM( @bsn1 := IF ( (m.team2 = 1 and m.neutral = 1), m.gol1, 0 ) ) AS bsn1, SUM( @bsn2 := IF ( (m.team1 = 1 and m.neutral = 1), m.gol2, 0 ) ) AS bsn2, SUM( @bzn1 + @bzn2 ) AS bzneut, SUM( @bsn1 + @bsn2 ) AS bsneut, SUM( @brzh + @brza + @bzn1 + @bzn2 - @brsh - @brsa - @bsn1 - @bsn2 ) AS roznicabramek, SUM( @brzh - @brsh) as rbh, SUM( @brza - @brsa) as rba, SUM( @bzn1 + @bzn2 - @bsn1 - @bsn2) as rbn, SUM( @brzh + @brza + @bzn1 + @bzn2 ) as bramkizdobyte, SUM( @brsh + @brsa + @bsn1 + @bsn2 ) as bramkistracone FROM mecz_nufc AS m, klub AS k WHERE ( m.team1 = $id OR m.team2 = $id ) AND ( gol1 IS NOT NULL ) and k.id = $id and m.rozgrywki != 18 GROUP BY k.nazwa") or die('Błąd zapytania: '.mysql_error()); if(mysql_num_rows($tabela) > 0) { while($r= mysql_fetch_assoc($tabela)) { echo " "; if ($r[rbh] > 0) echo ""; else echo ""; echo""; if ($r[rba] > 0) echo ""; else echo ""; echo ""; if ($r[rbn] > 0) echo ""; else echo ""; echo ""; if ($r[roznicabramek] > 0) echo ""; else echo ""; echo ""; }} echo "

GOSPODARZ	MR		X		BRAMKI			RB
Newcastle	".$r['meczh']."	".$r['wygh']."	".$r['remh']."	".$r['przegh']."	".$r['bzhome']."	:	".$r['bshome']."	+".$r['rbh']."	".$r['rbh']."
".$r['zespol']."	".$r['mecza']."	".$r['wyga']."	".$r['rema']."	".$r['przega']."	".$r['bzaway']."	:	".$r['bsaway']."	+".$r['rba']."	".$r['rba']."
Neutralny	".$r['meczen']."	".$r['zwyciestwan']."	".$r['remisyn']."	".$r['przegranen']."	".$r['bzneut']."	:	".$r['bsneut']."	+".$r['rbn']."	".$r['rbn']."
RAZEM	".$r['mecze']."	".$r['zwyciestwa']."	".$r['remisy']."	".$r['przegrane']."	".$r['bramkizdobyte']."	:	".$r['bramkistracone']."	+".$r['roznicabramek']."	".$r['roznicabramek']."

"; echo ""; $mecz = mysql_query("SELECT k1.short klub1, k2.short klub2, m.*, r.skrot comp, r.nazwa rozg, DATE_FORMAT(m.data, '%d.%m.%Y') kiedy FROM klub k1, klub k2, mecz_nufc m, rozgrywki r WHERE (m.team1 = $id or m.team2 = $id) and r.id = m.rozgrywki and k1.id = m.team1 and k2.id = m.team2 and ( gol1 IS NOT NULL ) and m.rozgrywki != 18 ORDER by data DESC") or die(mysql_error()); if(mysql_num_rows($mecz) > 0) { while($m= mysql_fetch_assoc($mecz)) { echo ""; }} echo "

WYNIKI MECZÓW
".$m['kiedy']."	".$m['comp']."	".$m['klub1']."	".$m['gol1']."	:	".$m['gol2']."	".$m['klub2'].""; if ($m['neutral'] == 1) echo " (obiekt neutralny)"; echo "

"; ?>