GoloHobbit Statistics";
echo "
";
echo "
".$num." Hobbits in ".$num2." languages: |
";
echo " | | | | ";
echo "
";
$query="SELECT L.idlang,L.language,H.cnt FROM languages L INNER JOIN (SELECT hobbits.langid,count(hobbits.langid) as cnt FROM hobbits GROUP BY hobbits.langid) H ON L.idlang=H.langid WHERE L.idlang LIKE 'zz%' ORDER BY L.language";
$datos = mysqli_query($link,$query);
$datosnum=mysqli_num_rows($datos);
echo "
";
echo "";
for ($i=1;$i<=$datosnum;$i++)
{
$row = mysqli_fetch_array($datos);
echo " - ".$row[1]." (".$row[2].")
";
}
echo " |
";
echo "| |
";
echo "
";
echo "
Tolkien in Other Languages
";
echo "
";
echo "";
$query="SELECT L.idlang,L.language,H.cnt FROM languages L INNER JOIN (SELECT hobbits.langid,count(hobbits.langid) as cnt FROM hobbits GROUP BY hobbits.langid) H ON L.idlang=H.langid WHERE L.idlang LIKE 'z9%' ORDER BY L.language";
$datos = mysqli_query($link,$query);
$datosnum=mysqli_num_rows($datos);
for ($i=1;$i<=$datosnum;$i++)
{
$row = mysqli_fetch_array($datos);
echo "- ".$row[1]." (".$row[2].")
";
}
echo " | ";
echo "
";
}
}
?>