$ok=true; $user="Sql1037212"; $password="d0860l2012"; $database="Sql1037212_5"; $localhost="89.46.111.32"; $con=mysql_connect($localhost,$user,$password); mysql_select_db($database) or die( "Unable to select database"); $query0809ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '37' AND '76' "; $query0809ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '37' AND '76' "; $query0910ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '1' AND '36' "; $query0910ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '1' AND '36' "; $query1011ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '77' AND '118' "; $query1011ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '77' AND '118' "; $query1112ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '119' AND '150' "; $query1112ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '119' AND '150' "; $query1213ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '151' AND '182' "; $query1213ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '151' AND '182' "; $query1314ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '183' AND '217' "; $query1314ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '183' AND '217' "; $query1415ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '218' AND '261' "; $query1415ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '218' AND '261' "; $query1516ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '262' AND '291' "; $query1516ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '262' AND '291' "; $query1617ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '292' AND '322' "; $query1617ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '292' AND '322' "; $query1718ffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '323' AND '400' "; $query1718ssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' AND ID BETWEEN '323' AND '400' "; $queryffc="SELECT COUNT(*) as tot, SUM(pa.GOL1) as golffc, SUM(pa.PUNTI1) as puntiffc FROM Partite pa WHERE pa.SQUADRA1='1' "; $queryssc="SELECT SUM(pa.GOL2) as golssc, SUM(pa.PUNTI2) as puntissc FROM Partite pa WHERE pa.SQUADRA2='2' "; $query0809="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '37' AND '76' "; $query0910="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '1' AND '36' "; $query1011="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '77' AND '118' "; $query1112="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '119' AND '150' "; $query1213="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '151' AND '182' "; $query1314="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '183' AND '217' "; $query1415="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '218' AND '261' "; $query1516="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '262' AND '291' "; $query1617="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '292' AND '322' "; $query1718="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' AND ID BETWEEN '323' AND '400' "; $query="SELECT * FROM Partite pa WHERE pa.SQUADRA1='1' "; $result0809ffc=mysql_query($query0809ffc,$con) or die(mysql_error()); $result0809ssc=mysql_query($query0809ssc,$con) or die(mysql_error()); $result0910ffc=mysql_query($query0910ffc,$con) or die(mysql_error()); $result0910ssc=mysql_query($query0910ssc,$con) or die(mysql_error()); $result1011ffc=mysql_query($query1011ffc,$con) or die(mysql_error()); $result1011ssc=mysql_query($query1011ssc,$con) or die(mysql_error()); $result1112ffc=mysql_query($query1112ffc,$con) or die(mysql_error()); $result1112ssc=mysql_query($query1112ssc,$con) or die(mysql_error()); $result1213ffc=mysql_query($query1213ffc,$con) or die(mysql_error()); $result1213ssc=mysql_query($query1213ssc,$con) or die(mysql_error()); $result1314ffc=mysql_query($query1314ffc,$con) or die(mysql_error()); $result1314ssc=mysql_query($query1314ssc,$con) or die(mysql_error()); $result1415ffc=mysql_query($query1415ffc,$con) or die(mysql_error()); $result1415ssc=mysql_query($query1415ssc,$con) or die(mysql_error()); $result1516ffc=mysql_query($query1516ffc,$con) or die(mysql_error()); $result1516ssc=mysql_query($query1516ssc,$con) or die(mysql_error()); $result1617ffc=mysql_query($query1617ffc,$con) or die(mysql_error()); $result1617ssc=mysql_query($query1617ssc,$con) or die(mysql_error()); $result1718ffc=mysql_query($query1718ffc,$con) or die(mysql_error()); $result1718ssc=mysql_query($query1718ssc,$con) or die(mysql_error()); $resultssc=mysql_query($queryssc,$con) or die(mysql_error()); $resultffc=mysql_query($queryffc,$con) or die(mysql_error()); $result0809=mysql_query($query0809,$con) or die(mysql_error()); $result0910=mysql_query($query0910,$con) or die(mysql_error()); $result1011=mysql_query($query1011,$con) or die(mysql_error()); $result1112=mysql_query($query1112,$con) or die(mysql_error()); $result1213=mysql_query($query1213,$con) or die(mysql_error()); $result1314=mysql_query($query1314,$con) or die(mysql_error()); $result1415=mysql_query($query1415,$con) or die(mysql_error()); $result1516=mysql_query($query1516,$con) or die(mysql_error()); $result1617=mysql_query($query1617,$con) or die(mysql_error()); $result1718=mysql_query($query1718,$con) or die(mysql_error()); $result=mysql_query($query,$con) or die(mysql_error()); $database="Sql1037212_1"; mysql_select_db($database) or die( "Unable to select database"); //mysql_close($con); ?>
Villa Flaminia
ANNO | SQUADRA | PART | VIN | NUL | PER | GOL F | GOL S | PUNTI | % V | % N | % P |
---|---|---|---|---|---|---|---|---|---|---|---|
2008 – 2009 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2008 – 2009 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2009 – 2010 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2009 – 2010 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2010 – 2011 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?>* | =$pervinte?> | =$pernulle?> | =$perperse?> |
2010 – 2011 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?>* | =$perperse?> | =$pernulle?> | =$pervinte?> |
2011 – 2012 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2011 – 2012 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2012 – 2013 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2012 – 2013 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2013 – 2014 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2013 – 2014 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2014 – 2015 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2014 – 2015 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2015 – 2016 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2015 – 2016 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
2016 – 2017 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?>* | =$pervinte?> | =$pernulle?> | =$perperse?> |
2016 – 2017 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?>* | =$perperse?> | =$pernulle?> | =$pervinte?> |
2017 – 2018 | FavaFootballClub | =$partite?> | =$vinte?> | =$nulle?> | =$perse?> | =$row1['golffc']?> | =$row2['golssc']?> | =$row1['puntiffc']?> | =$pervinte?> | =$pernulle?> | =$perperse?> |
2017 – 2018 | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?> | =$perperse?> | =$pernulle?> | =$pervinte?> |
TOTALE | SSCharbonnier | =$partite?> | =$perse?> | =$nulle?> | =$vinte?> | =$row2['golssc']?> | =$row1['golffc']?> | =$row2['puntissc']?>* | =$perperse?> | =$pernulle?> | =$pervinte?> |
* 1 Partita persa a tavolino dalla FFC per antisportività