Sčítání, tabulka

@$zapasy = mysql_query ("select sazky.*, zapasy.* FROM sazky, zapasy WHERE saz_uzivatel='$_SESSION[UserId]' AND sazky.saz_zapas=zapasy.id AND zapasy.score!=''");
  while ($zapas = @mysql_fetch_array($zapasy)){ 
$datum = strftime("%d/%m/%Y %H:%M", $zapas[datum]);
$datum_sazky = strftime("%d/%m/%Y %H:%M", $zapas[saz_datum]);
  list($skore_domaci,$score_hoste)=explode(':',$zapas[score]);
   if($skore_domaci>$score_hoste){$spravny_tip='1';}
    elseif($skore_domaci==$score_hoste){$spravny_tip='0';}
     elseif($skore_domaci<$score_hoste){$spravny_tip='2';}
      if($spravny_tip==$zapas[saz_tip]){$bod[]='1';}

$bodu=count($bod);
$pocet=mysql_num_rows(mysql_query("SELECT zapasy.*,sazky.* FROM sazky, zapasy WHERE zapasy.id=sazky.saz_zapas AND sazky.saz_uzivatel='$_SESSION[UserId]' AND zapasy.score!=''"));
$procent = round(100* ($bodu/ $pocet));

SELECT 
CASE 
 WHEN zapasy.vysledek_d>zapasy.vysledek_h THEN '1'
 WHEN zapasy.vysledek_d<zapasy.vysledek_h THEN '2' 
 ELSE '0'
END AS spravny_tip FROM zapasy, sazky WHERE zapasy.id=sazky.saz_zapas AND sazky.saz_id=253

SELECT 
SUM(zapasy.zap_tip=sazky.saz_tip) AS spravnych_tipu,
count(*) vsech_tipu, sazky.saz_uzivatel, uzivatele.jmeno
FROM zapasy, sazky, uzivatele WHERE zapasy.id=sazky.saz_zapas AND sazky.saz_uzivatel=uzivatele.id AND zapasy.vysledek_d IS NOT NULL GROUP BY sazky.saz_uzivatel

$procent = round(100* ($vypis[spravnych_tipu]/ $vypis[vsech_tipu]));