openside("");



$db = Array('host' => 'localhost',

			'user' => 'user',

			'pass' => 'hasło',

			'database' => 'nazwabazy');



function DB_query($query) {

	global $db;



	$conn = mysql_connect($db[host], $db[user], $db[pass]);

	mysql_select_db($db[database], $conn);

	$result = mysql_query($query);

	mysql_close($conn);



	return $result;

}



function DB_fetch_array($query) {

	global $db;



	$conn = mysql_connect($db[host], $db[user], $db[pass]);

	mysql_select_db($db[database], $conn);

	$result = mysql_fetch_array($query);

	mysql_close($conn);



	return $result;

}



echo "<FIELDSET><LEGEND><b>TOP 5 EKSTRAKLASY:</b></LEGEND>

<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse\" bordercolor=\"#6B6D6B\" align=\"center\" width=\"150\">

	<tr>

<td width=\"25\" align=\"center\"><font color=\"#FFFFFF\"><b>Lp</b></font></td>

<td width=\"100\" align=\"center\"><font color=\"#FFFFFF\"><b>nazwa usera</b></font></td>

<td width=\"25\" align=\"center\"><font color=\"#FFFFFF\"><b>pkt</b></font></td>

</tr>";





$query = DB_query("SELECT userid, position, points FROM plstandings ORDER BY position ASC LIMIT 5");



while ($data = DB_fetch_array($query)) 

	{

	$query2 = DB_query("SELECT username FROM pluserdata WHERE userid = '".$data[userid]."'");

	$data2 = DB_fetch_array($query2);



	echo "<tr>

 <td align=\"center\"><font color=\"#ffffff\">".$data[position]."</font></td>

 <td align=\"center\"><font color=\"#ffffff\">".$data2[username]."</font></td>

 <td align=\"center\"><font color=\"#ffffff\">".$data[points]."</font></td>

</tr>";



	}



echo "</table></FIELDSET>";





closeside();

$link = dbconnect($db_host, $db_user, $db_pass, $db_name);