".(($_GET[EV]!="2005")?"":(""))."2005"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $con = mysql_connect("localhost","repoktor_szauer","szauer"); if (!$con) { die('Could not connect: ' . mysql_error()); } $sorok=mysql_query("set names 'utf8'"); $sorok=mysql_query("use repoktor_mvkweb"); $sorok=mysql_query("select p.id,p.nev,r2005.pontszam e5,r2006.pontszam e6,r2007.pontszam e7,r2008.pontszam e8,r2009.pontszam e9,r2010.pontszam e10,r2011.pontszam e11,r2012.pontszam e12,r2013.pontszam e13 from ranglista_pilota p left outer join ranglista_ranglistapont as r2008 on r2008.pilota_id=p.id and r2008.ev='2008' and r2008.kat is null left outer join ranglista_ranglistapont as r2007 on r2007.pilota_id=p.id and r2007.ev='2007' and r2007.kat is null left outer join ranglista_ranglistapont as r2006 on r2006.pilota_id=p.id and r2006.ev='2006' and r2006.kat is null left outer join ranglista_ranglistapont as r2005 on r2005.pilota_id=p.id and r2005.ev='2005' and r2005.kat is null left outer join ranglista_ranglistapont as r2009 on r2009.pilota_id=p.id and r2009.ev='2009' and r2009.kat is null left outer join ranglista_ranglistapont as r2010 on r2010.pilota_id=p.id and r2010.ev='2010' and r2010.kat is null left outer join ranglista_ranglistapont as r2011 on r2011.pilota_id=p.id and r2011.ev='2011' and r2011.kat is null left outer join ranglista_ranglistapont as r2012 on r2012.pilota_id=p.id and r2012.ev='2012' and r2012.kat is null left outer join ranglista_ranglistapont as r2013 on r2013.pilota_id=p.id and r2013.ev='2013' and r2013.kat is null order by r$_GET[EV].pontszam desc"); $i=1; while ($sor=mysql_fetch_array($sorok)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i++; } ?>
Helyezés Név ".(($_GET[EV]!="2006")?"":(""))."2006 ".(($_GET[EV]!="2007")?"":(""))."2007 ".(($_GET[EV]!="2008")?"":(""))."2008 ".(($_GET[EV]!="2009")?"":(""))."2009 ".(($_GET[EV]!="2010")?"":(""))."2010 ".(($_GET[EV]!="2011")?"":(""))."2011 ".(($_GET[EV]!="2012")?"":(""))."2012 ".(($_GET[EV]!="2013")?"":(""))."2013
$i$sor[nev]$sor[e5]$sor[e6]$sor[e7]$sor[e8]$sor[e9]$sor[e10]$sor[e11]$sor[e12]$sor[e13]