<?php
// pocz±tek ----------------------------->
session_start();

require_once("db_class.php");
$db = new db();
$db -> connect();
if (!isset($_GET['lang']) || !preg_match('/^([a-z]{2})$/', $_GET['lang']))
{
	$_GET['lang'] = 'pl';
	if (!isset($_SESSION['language']))
	{
		$_SESSION['language'] = 'pl';
	}
}
 else
{
	$_SESSION['language'] = $_GET['lang'];
}
	
require("lang/".$_SESSION['language'].".php");


$db -> queryp("SELECT date, skrot FROM system WHERE type='academy'");
if($db -> numrows == 0) {
$academys = "<font color=white>Brak</font>";
} else {
$academys = "<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=klub&co=>Brak</a><br>";
while($row=mysql_fetch_array($db -> results))  {
$academys .= "<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=klub&co=".$row['skrot'].">".$row['date']."</a><br>";
}
}



switch($_SESSION['language']) {
case 'pl' :
$stopien = "
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=>Brak</a><br><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-4>Czarny IIII</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-3>Czarny III</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-2>Czarny II</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-1>Czarny I</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny>Czarny</a> <br>


<Br>

<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-4>Brazowy IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-3>Brazowy III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-2>Brazowy II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-1>Brazowy I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy>Brazowy</a><br>



<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-4>Purpurowy IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-3>Purpurowy III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-2>Purpurowy II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-1>Purpurowy I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy>Purpurowy</a><br>

<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-4>Niebieski IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-3>Niebieski III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-2>Niebieski II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-1>Niebieski I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski>Niebieski</a><br>

<br>

<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-4>Bia³y IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-3>Bia³y III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-2>Bia³y II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-1>Bia³y I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y>Bia³y</a><br>

<br>





";
break;
case 'en':
$stopien = "

<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=>Empty</a><br><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-4>Black IIII</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-3>Black III</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-2>Black II</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny-1>Black I</a> <br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=czarny>Black</a> <br>


<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-4>Brown IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-3>Brown III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-2>Brown II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy-1>Brown I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=br±zowy>Brown</a><br>

<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-4>Purpure IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-3>Purpure III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-2>Purpure II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy-1>Purpure I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=purpurowy>Purpure</a><br>
<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-4>Blue IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-3>Blue III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-2>Blue II</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski-1>Blue I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=niebieski>Blue</a><br>


<br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-4>White IIII</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-3>White III</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-2>White II</a><br
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y-1>White I</a><br>
<a href=index.php?lang=".$_SESSION['language']."&step=dodaj&typ=pas&co=bia³y>White</a><br>
>


<br>




";
break;

}


// -------------------------------------->


//pobieranie danych ------------------>
if(isSet($_GET['step'])) {
switch($_GET['step']) {
case 'klub' : // klub
$academy = array(
'GBT'=>'GB Toruñ',
'GBTK'=>'GB Bastion Tychy Katowice',
'GBL'=>'GB £ód¼',
'GBMP'=>'GB MMA Poznañ'
);
foreach($academy as $key => $v) {
$academy[$key] = $v;
}

$db -> queryp("SELECT * FROM zawodnicy WHERE club='".$academy[$_GET['co']]."' order by prename ASC");  
 

break;
case 'dodaj' : // pas
if(isSet($_GET['typ']) && isSet($_GET['co'])) {


switch($typ) {
case'pas' :
$_SESSION['pas'] = $_GET['co'];
break;
case 'klub' :
if($_GET['co'] != '') {
$db -> query("SELECT date FROM system WHERE skrot='".$_GET['co']."'", 'select');
if($db -> numrows != 0) {
$akademia = $db -> field['date'];
}
} else {
$akademia = '';
}
$_SESSION['klub'] = $akademia;

break;
}

} 
$body ="<div id=hello>
".$lang['hello']."
</div>
<br><img src=img/pasek.png>"; 
break;

case'form' : //form

$i =0;
if($_POST['prename'] != '' && $_POST['prename'] != $lang['prename']) { $query .= "prename LIKE '%".$_POST['prename']."%'";  $i++;} //prename
if($_SESSION['klub'] != '') { // clubs
if($i > 0) {
$query .= " AND club = '".$_SESSION['klub']."'";
} else {
$query .= "club = '".$_SESSION['klub']."'";
}
$i++;
}
if($_SESSION['pas'] != '') { //colors
$colorwpis = explode("-", $_SESSION['pas']);
if($colorwpis['0'] != '') {
if($i > 0) {
$query .= " AND color = '".$colorwpis['0']."'";
} else {
$query .= "color = '".$colorwpis['0']."'"; 
}
$i++;
}
if($colorwpis['1'] != '') {
if($i > 0) {
$query .= "AND belka = ".$colorwpis['1']."";
} else {
$query .= "belka = ".$colorwpis['1'].""; 
}
$i++;
}
}

if($_POST['date'] != '' && $_POST['date'] != $lang['date']) { //date

$dataarr = explode(", ", $_POST['date']);



if($dataarr['0'] != '') {
$datatab = explode(",", $dataarr['0']);

$miesiactab = array
('January' => 'Styczeñ',
'Fabruary'  => 'Luty',
'March' => 'Marzec',
'April' => 'Kwiecieñ',
'May' => 'Maj',
'June' => 'Czerwiec',
'July' => 'Lipiec',
'August' => 'Sierpieñ',
'September' => 'Wrzesieñ',
'October' => 'Pa¼dziernik',
'November' => 'Listopad',
'December' => 'Grudzieñ'
);
foreach($miesiactab as $key => $v) {
$miesiactab[$key] = $v;
}
switch($_SESSION['language']) {
case 'en' :
$datapob = "".$datatab['0'].".".$miesiactab[$datatab['1']].".".$datatab['2']."";
break;
case 'pl':
$datapob = "".$datatab['0'].".".$datatab['1'].".".$datatab['2']."";
break;

}

if($i > 0) {
$query .= " AND date = '".$datapob."'";
} else {
$query .= "date = '".$datapob."'";
}
$i++;
} 
if($dataarr['1'] != '') {
if($i > 0) {
$query .= " AND who = '".$dataarr['1']."'";
} else {
$query .= "who = '".$dataarr['1']."'";
}
$i++;
}
if($dataarr['2'] != '') {
if($i > 0) {
$query .= " AND gdzie = '".$dataarr['2']."'";
} else {
$query .= "gdzie = '".$dataarr['2']."'";
}
$i++;
}




}


if($i != 0) {

$db -> queryp("SELECT * FROM zawodnicy WHERE ".$query." order by showorder DESC"); // query !

$body = '';
}


break;

default :
$_GET['step'] = '';
break;


}


// pobieranie ----------------------------------->
if($db -> numrows == 0) {
$body=$lang['nexist'];
} else {
$miesiactab = array
('Styczeñ' => 'January',
'Luty'  => 'Fabruary',
'Marzec' => 'March',
'Kwiecieñ' => 'April',
'Maj' => 'May',
'Czerwiec' => 'June',
'Lipiec' => 'July',
'Sierpieñ' => 'August',
'Wrzesieñ' => 'September',
'Pa¼dziernik' => 'October',
'Listopad' => 'November',
'Grudzieñ' => 'December'
);

$colortab = array
(
'bia³y' => 'White',
'niebieski' =>'Blue',
'purpurowy' => 'Purpure',
'br±zowy' => 'Brown',
'czarny' => 'Black'
);
$belkitab = array
('0' => '',
'1' => 'I',
'2' => 'II',
'3' => 'III',
'4' => 'IIII'

);
while($row=mysql_fetch_array($db -> results)) {

 switch($_SESSION['language']) {
case 'en' :
$color= $colortab[$row['color']];
break;
case 'pl' :
$color= $row['color'];
break;
}




$query = "SELECT * FROM zawodnicy_daty WHERE id=".$row['id']." ORDER BY orderdate DESC";
$query = mysql_query($query); 
$numrows = mysql_num_rows($query);

  if($numrows == 0) {
   $data= '';
  }else {
    while($row2=mysql_fetch_array($query)) {
     switch($_SESSION['language']) {
case 'en' :

foreach($miesiactab as $key => $v) {
$miesiactab[$key] = $v;
$array = explode(".", $row2['date']);
$miesiac = $miesiactab[$array['1']];
$dat = "".$array['0'].".".$miesiac.".".$array['2']."";
}

foreach($colortab as $key => $v) {
$colortab[$key] = $v;
}

$kolor =$colortab[$row2['what']];

break;
case 'pl' :
$kolor=$row2['what'];
$dat = $row2['date'];

break;
}


    $data .= "-".$kolor.", ".$row2['belka']." ".$lang['belka']." - ".$dat." ".$lang['nadana']." ".$row2['who'].", ".$row2['gdzie']."<Br>";
    }

}


$body .= "<div id=avatar>

<img src=img/min/".$row['img'].">

</div>
<div id=block>
<b>".$lang['name']." ".$lang['prename'].":</b> ".$row['name']." ".$row['prename']." <br>
<b>".$lang['academy'].":</b> ".$row['club']."<br>
<b>".$lang['stopien'].":</b> ".$color."  ".$belkitab[$row['belka']]."<Br>
<b>".$lang['history']."</b> <br>
".$data."
<br>
</div> <br><img src=img/pasek.png><br>

";
$data = '';
}
}




} else {
$body ="<div id=hello>
".$lang['hello']."
</div>
<br><img src=img/pasek.png>"; 
}
// wyswietlanie danych --------------------------------------------->


if(!isSet($_SESSION['klub']) || $_SESSION['klub'] == '') {
$academy = $lang['academy'];
} else {
$academy = $_SESSION['klub'];
}

if(!isSet($_SESSION['pas']) || $_SESSION['pas'] == '') {
$echocolor = $lang['color'];
} else {
$colorwpis = explode("-", $_SESSION['pas']);
$belkitab = array
('0' => '',
'1' => 'I',
'2' => 'II',
'3' => 'III',
'4' => 'IIII'

);
$colortab = array
(
'bia³y' => 'White',
'niebieski' =>'Blue',
'purpurowy' => 'Purpure',
'br±zowy' => 'Brown',
'czarny' => 'Black'
);
foreach($colortab as $key => $v) {
$colortab[$key] = $v;
}
switch($_SESSION['language']) {
case 'pl':
$echocolor = "".$colorwpis['0']." ".$belkitab[$colorwpis['1']]."";
break;
case 'en' :
$echocolor =  "".$colortab[$colorwpis['0']]." ".$belkitab[$colorwpis['1']]."";
break;

}


}



echo "<html>
<head>
<link rel=Stylesheet type=text/css href=style.css />
<script type=text/javascript>
function combo(id) {
id=document.getElementById(id);
id.style.visibility=id.style.visibility=='hidden'?'visible':'hidden';
}
function send(event) {
   event = (event)?event:((window.event)?event:null);
   if (event.keyCode==13) document.formularz.submit();
}

</script>



</head>
<body>


<center><div id=all>

<div id=img>

<table border=0 cellspacing=0 cellpadding=0 width=800>
<tr>
<td id=up>
<table width=800 border=0 cellspacing=0 cellpadding=0 >
<tr>
<td width=720>
</td>
<td>
<a href=index.php?lang=pl><img border=0 alt=0 src=img/flaga-p.png></a> <a  href=index.php?lang=en><img border=0 alt=0 src=img/flaga-a.png></a>
</td>
</tr>
</table>

</td>
</tr>

<tr>

<td id=down>
".$lang['up']."
</td>
</tr>
</div>
</table>
	

	<object classid=\"clsid27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0\" width=\"800\" height=\"200\" id=\"baner_draculino\" align=\"middle\">
<param name=\"allowScriptAccess\" value=\"sameDomain\" />
<param name=\"allowFullScreen\" value=\"false\" />
<param name=\"movie\" value=\"baner_draculino.swf\" /><param name=\"quality\" value=\"high\" /><param name=\"bgcolor\" value=\"#003366\" /> <embed src=\"img/baner_draculino.swf\" quality=\"high\" bgcolor=\"#003366\" width=\"800\" height=\"200\" name=\"baner_draculino\" align=\"middle\" allowScriptAccess=\"sameDomain\" allowFullScreen=\"false\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />
</object>



<div id=search>
<form action='index.php?lang=".$_SESSION['language']."&step=form' method=post>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td id=down>
".$lang['search']."
</td>
</tr>
</table>
<center><table border=0 cellspacing=0 cellpadding=0 width=800>
<tr>

<td>
 <table align=center>
<tr><td>
<table width=140 border=0 cellspacing=0 cellpadding=0
bordercolor=#000000>
<tr>
<td bgcolor=000000>
<font face=verdana size=2 color=white>".$academy."
</td>
<td align=right width=21>
<img src=img/strzalka.jpg name=combo_arrow
width=21 height=21 alt=
border=0 onclick=combo('drugie') ></td>
</tr>
</table>
<div id='drugie' style='position:absolute;
left:?px; top:?px; width:?px;
height:?px; z-index:1; visibility:hidden'>
<table width=200 border=1 cellspacing=0 cellpadding=0
bordercolor=#d8d8d8 onmouseout=combo('drugie') onclick=combo('drugie')>
<tr>
<td bgcolor=000000>
".$academys."



</td>
</tr>
</table>
</td></tr>
</table>

</td>
<td>
 <table align=center>
<tr><td>
<table width=140 border=0 cellspacing=0 cellpadding=0
bordercolor=000000>
<tr>
<td bgcolor=000000>
<font face=verdana size=2 color=white> ".$echocolor."
</td>
<td align=right width=21>
<img src=img/strzalka.jpg name=combo_arrow
width=21 height=21 alt=
border=0 onclick=combo('trzecie') ></td>
</tr>
</table>
<div id='trzecie' style='position:absolute;
left:?px; top:?px; width:?px;
height:?px; z-index:1; visibility:hidden'>
<table width=150 border=1 cellspacing=0 cellpadding=0
bordercolor=#000000 onmouseout=combo('trzecie') onclick=combo('trzecie')>
<tr>
<td bgcolor=#000000>
".$stopien."



</td>
</tr>
</table>
</td></tr>
</table>
</td>
<td>
<table align=center>
<tr><td>
<table width=140 border=0 cellspacing=0 cellpadding=0
bordercolor=000000>
<tr>
<td bgcolor=000000>
<font face=verdana size=2 color=white> <input id=form type=text name=prename value='".$lang['prename']."'>
</td>
<td align=right width=21>
<img src=img/znakzapytania.jpg name=combo_arrow
width=21 height=21 alt=
border=0 onclick=combo('helpname') ></td>
</tr>
</table>
<div id='helpname' style='position:absolute;
left:?px; top:?px; width:?px;
height:?px; z-index:1; visibility:hidden'>
<table width=300 border=1 cellspacing=0 cellpadding=0
bordercolor=#000000 onmouseout=combo('helpname') onclick=combo('helpname')>
<tr>
<td bgcolor=#000000>
<font color=white size=2>".$lang['namehelp']."
</font>


</td>
</tr>
</table>
</td></tr>
</table>

</td>
<td>
<table align=center>
<tr><td>
<table width=140 border=0 cellspacing=0 cellpadding=0
bordercolor=000000>
<tr>
<td bgcolor=000000>
<font face=verdana size=2 color=white> <input id=form type=text name=date value='".$lang['date']."'>
</td>
<td align=right width=21>
<img src=img/znakzapytania.jpg name=combo_arrow
width=21 height=21 alt=
border=0 onclick=combo('helpdate') ></td>
</tr>
</table>
<div id='helpdate' style='position:absolute;
left:?px; top:?px; width:?px;
height:?px; z-index:1; visibility:hidden'>
<table width=300 border=1 cellspacing=0 cellpadding=0
bordercolor=#000000 onmouseout=combo('helpdate') onclick=combo('helpdate')>
<tr>
<td bgcolor=#000000>
<font color=white size=2>".$lang['datehelp']."
</font>



</td>
</tr>
</table>
</td></tr>
</table>
</td>
<td>

<input type=submit value=".$lang['button'].">

</td>


</tr>



</table>
<table border=0 cellspacing=0 cellpadding=0>
<tr>
<td id=down height=25>

</td>


</tr>
</table> </center>

     
</form>
</div>

".$body."

<div id=bottom>

</div>

</div></center>

</body>
</html>";
?>

...
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head> 
<link rel=Stylesheet type=text/css href=style.css />
<script type=text/javascript>
function combo(id) {
id=document.getElementById(id);
id.style.visibility=id.style.visibility=='hidden'?'visible':'hidden';
}
function send(event) {
   event = (event)?event:((window.event)?event:null);
   if (event.keyCode==13) document.formularz.submit();
}

</script> 
</head> 
<body> 
<center>
<div id=all> 
<div id=img> 
<table border=0 cellspacing=0 cellpadding=0 width=800> <tr> <td id=up> 
<table width=800 border=0 cellspacing=0 cellpadding=0 > <tr> <td width=720> </td> 
<td> <a href=index.php?lang=pl><img border=0 alt=0 src=img/flaga-p.png></a> <a  href=index.php?lang=en><img border=0 alt=0 src=img/flaga-a.png></a> </td> 
</tr> </table>  </td> </tr> <tr> <td id=down><?=$lang['up']?>
</td> </tr> </div> </table> 
<object width="800" height="200" id="baner_draculino" data="baner_draculino.swf" type="application/x-shockwave-flash"> 
<param name="allowScriptAccess" value="sameDomain" />
<param name="allowFullScreen" value="false" />
<param name="movie" value="baner_draculino.swf" />
<param name="quality" value="high" />
<param name="bgcolor" value="#003366" />
</object> 
<div id=search>
<form action="index.php?lang=<?=$_SESSION['language']?>&step=form" method=post> 
<table border=0 cellspacing=0 cellpadding=0> <tr> <td id=down><?=$lang['search']?>
</td> </tr> 
</table> <center>
<table border=0 cellspacing=0 cellpadding=0 width=800> <tr> <td> <table align=center> <tr><td> 
<table width=140 border=0 cellspacing=0 cellpadding=0
bordercolor=#000000> <tr> <td bgcolor=000000> <font face=verdana size=2 color=white><?=$academy?>
</td> <td align=right width=21> <img src=img/strzalka.jpg name=combo_arrow width=21 height=21 alt="" border=0 onclick=combo('drugie') ></td> </tr> </table> 
<div id='drugie' style='position:absolute;
left:?px; top:?px; width:?px;
height:?px; z-index:1; visibility:hidden'> <table width=200 border=1 cellspacing=0 cellpadding=0
bordercolor=#d8d8d8 onmouseout=combo('drugie') onclick=combo('drugie')> <tr> <td bgcolor=000000>
<?=$academys?>
...

$db -> queryp("SELECT * FROM zawodnicy WHERE club='".$academy[$_GET['co']]."' order by prename ASC");