Spil database

Kode 

Tabeller:
> tbl_rounds
	- pk_rounds (int, primary key)
	- fk_profiles (int)
	- points (int)

> tbl_profiles
	- pk_profiles (int, primary key)
	- name (varchar)

> tbl_players
	- pk_players (int, primary key)
	- fk_profiles (int)
	- fk_teams (int)
	- position (enum: goal,defence_right,defence_left,midfield_right,midfield_left,offence)
	
> tbl_teams
	- pk_teams (int, primary key)
	- name (varchar)
	
	
Player points SQL:
SELECT name, SUM(points) AS points
FROM tbl_rounds
JOIN tbl_profiles ON pk_profiles = fk_profiles
GROUP BY pk_profiles

Team points SQL:
SELECT tbl_teams.name, SUM(points) AS points
FROM tbl_teams
JOIN tbl_players ON pk_teams = fk_teams
JOIN tbl_points ON tbl_points.fk_profiles = tbl_players.fk_profiles
GROUP BY pk_teams

Kode 

<?
  

$query = mysql_query("SELECT profileid, SUM(point)
FROM runder
WHERE profileid
GROUP BY profileid ORDER BY SUM(point) DESC");
while($row = mysql_fetch_assoc($query)) 
{ 
    echo $row['profileid'] . " - " . $row['SUM(point)'] . "<br/>"; 
} 
?> 

Kode 

<?
  

$query = mysql_query("SELECT holdid, SUM(point)
FROM runder 
JOIN hold ON profileid_m = profileid OR profileid_f1 = profileid OR profileid_f2 = profileid OR profileid_m1 = profileid OR profileid_m2 = profileid OR profileid_a = profileid
GROUP BY holdid ORDER BY SUM(point) DESC");
while($row = mysql_fetch_assoc($query)) 
{ 
    echo $row['holdid'] . " - " . $row['SUM(point)'] . "<br/>"; 
} 
?>