| -- Of the ".number_format($cardsum)." cards in the Astroland collection, ".number_format($counter)."/".number_format($cardsum).", or 1 in ".number_format($cardsum/$counter,1).", are numbered | ";
$playersquery="SELECT COUNT(aname) FROM Numbertable WHERE trim(aname) != ''";
$playertotal=mysql_query($playersquery);
while($rowwhatever = mysql_fetch_array($playertotal)){
$playerstotal= $rowwhatever['COUNT(aname)'];}
echo "| -- Of the ".number_format($playerstotal)." players in the Astroland collection, ".number_format($i)."/".number_format($playerstotal).", or 1 in ".number_format($playerstotal/$i,1).", have a numbered card | ";
echo "
-- Among the ".number_format($i)." players in the Astroland collection with numbered cards, the average number of numbered cards per player
is ".$i."/".$counter.", or ".number_format($counter/$i,1)." | ";
if ($sortorder=="playerlastname") {if ($i%2==0) {$median=$numberedcards[$i/2];} else {$median=($numberedcards[floor($i/2)]+$numberedcards[ceil($i/2)])/2;}
echo "
| -- That\'s skewed a little bit, because of ".$playersfirstname[0]." ".$playersmiddlename[0]." ".$playerslastname[0]." and ".$playersfirstname[1]." ".$playersmiddlename[1]." ".$playerslastname[1]." and the rest. The median as you can see is ".$median." | ";}
else {$topguy=max($numberedcards);
$topguykey = array_search($topguy,$numberedcards);
rsort($numberedcards);
$middle = round(count($numberedcards) / 2);
$total = $numberedcards[$middle-1];
echo "
| -- That\'s skewed a bit, because of ".$playersfirstname[$topguykey]." ".$playersmiddlename[$topguykey]." ".$playerslastname[$topguykey]." and the rest of the stars with the very most cards. The median for the ".$i." is ".$total." | ";}
echo "