zczytanie danych do tablicy Opcje

[piczu]

mam tavlice z danymu :

Kod

home_club_id | away_club_id | home_goals | away_goals

sa to mecze ligowe
chce je podliczyc aby stworzyc tabele ale mam rozne problemy.
chcialbym strorzyc tablice $tablica['club_id'] = ('home_goals_plus','home_goals_minus', itd.)
ale id klubow mam nie ciagłe wiec mialbym problem z przejsciem do nastepnego elementu. juz ciezko mi sie mysli, poradzcie cos.

[piczu]

oto caly moj kod:

[PHP] pobierz, plaintext 
<?php
$query='SELECT * FROM leagues';
$_SESSION['db']->query($query);
while ($leagues = $_SESSION['db']->fetchArray()) {
$table[$leagues['home_club_id']][&#092;"home_goals_plus\"] += $leagues['home_goals'];
$table[$leagues['home_club_id']][&#092;"home_goals_minus\"] += $leagues['away_goals'];
$table[$leagues['home_club_id']][&#092;"home_matches\"] ++;
$table[$leagues['away_club_id']][&#092;"away_goals_plus\"] += $leagues['away_goals'];
$table[$leagues['away_club_id']][&#092;"away_goals_minus\"] += $leagues['home_goals'];
$table[$leagues['away_club_id']][&#092;"away_matches\"] ++;
if ($leagues['away_goals']>$leagues['home_goals']) {
	$table[$leagues['away_club_id']][&#092;"away_wins\"] ++;
	$table[$leagues['away_club_id']][&#092;"away_pts\"] += 3;
	$table[$leagues['home_club_id']][&#092;"home_loses\"] ++;
} elseif ($leagues['away_goals']<$leagues['home_goals']) {
	$table[$leagues['home_club_id']][&#092;"home_wins\"] ++;
	$table[$leagues['home_club_id']][&#092;"home_pts\"] += 3;
	$table[$leagues['away_club_id']][&#092;"away_loses\"] ++;
} else {
	$table[$leagues['home_club_id']][&#092;"home_draws\"] ++;
	$table[$leagues['home_club_id']][&#092;"home_pts\"] += 1;
	$table[$leagues['away_club_id']][&#092;"away_draws\"] ++;
	$table[$leagues['away_club_id']][&#092;"away_pts\"] += 1;
}
}
 
?>
[PHP] pobierz, plaintext 

zsumowalem wszystkie mecze aby zrobic tabele ligowa
i teraz jak wyciagnac tabele posortowana wzgledem home_pts+away_pts;