Helyezés |
Név |
".(($_GET[EV]!="2005")?"":(""))."2005";
echo " ".(($_GET[EV]!="2006")?"":(""))."2006 | ";
echo " ".(($_GET[EV]!="2007")?"":(""))."2007 | ";
echo " ".(($_GET[EV]!="2008")?"":(""))."2008 | ";
echo " ".(($_GET[EV]!="2009")?"":(""))."2009 | ";
echo " ".(($_GET[EV]!="2010")?"":(""))."2010 | ";
echo " ".(($_GET[EV]!="2011")?"":(""))."2011 | ";
echo " ".(($_GET[EV]!="2012")?"":(""))."2012 | ";
echo " ".(($_GET[EV]!="2013")?"":(""))."2013 | ";
$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 "$i | ";
echo "$sor[nev] | ";
echo "$sor[e5] | ";
echo "$sor[e6] | ";
echo "$sor[e7] | ";
echo "$sor[e8] | ";
echo "$sor[e9] | ";
echo "$sor[e10] | ";
echo "$sor[e11] | ";
echo "$sor[e12] | ";
echo "$sor[e13] | ";
echo "
";
$i++;
}
?>