udregne gennemsnitsalder
Jeg har nedenstående, der udskriver ryttere og deres alder.Jeg har rodet for at udregne deres gennemsnitsalder, uden held:
MIN(aa.year) AS year,
aa.hold AS hold,
aa.nummer AS nummer,
aa.navn AS navn,
aa.start AS staart,
ryt.flags AS flags,
ryt.id AS rytterid,
ryt.name AS ryttername,
ryt.country AS country,
ryt.logo AS logo,
ryt.born AS born,
te.id AS teamid,
te.deltaget AS deltaget,
te.name AS teamname,
DATEDIFF(aa.start, ryt.born) as alder
FROM alleaar AS aa
INNER JOIN ryttere AS ryt ON aa.navn = ryt.id
INNER JOIN teams AS te ON aa.hold = te.id
WHERE aa.year=$aar AND aa.navn = ryt.id AND te.id=$hold
GROUP BY
ryt.name HAVING year = $aar
ORDER BY aa.nummer ASC
");
while($r = mysql_fetch_array($res))
{
$antaldage = $r['alder'];
$beregn = floor($antaldage/365);
$antaldage = $beregn ." Years " . ($antaldage - ($beregn*365)) . " Days";
echo "<table width='630' border='0' cellspacing='0' cellpadding='0'><tr><td style='border-top:ridge 1px #FFFF80;'>";
echo "<table width='630' border='0' cellspacing='1' cellpadding='1'><tr>";
echo "<td width='30' align='right' valign='bottom'>$r[nummer].</td>";
echo "<td width='25' align='center' valign='bottom'><img src=$r[flags] width='15' height='15' border=0></td>";
echo "<td width='200' align='left' valign='bottom'><img src=$r[logo] width='15' height='20' border=0> <a href=http://www.tourfacts.dk/root/tour_de_france_riders.php?id=$r[rytterid] class='link2' target='_self'>$r[ryttername]</a></td>";
echo "<td width='140' align='left' valign='bottom'>$antaldage</td>";
echo "<td width='125' align='left' valign='bottom'>$r[country]</td>";
echo "<td width='55' align='left' valign='bottom'><em><font color='#FF0000'>";
$out = mysql_query("SELECT * FROM out WHERE year = $aar AND name = $r[rytterid]");
while($o = mysql_fetch_array($out)) { echo "Stage: $o[etape]"; }
echo"</font></em></td>";
echo "</tr></table>";
echo "</td></tr></table>";
}
$number = 0;
Skulle der mon være en løsning på dette?