";
echo "
".$pageText[0]."
";
echo "";
echo "| ".$pageText[1];
echo " | ".$pageText[2];
echo " | ".$pageText[3];
echo " | ".$pageText[4];
echo " |
";
include("config.php");
$conn = mysql_connect($hostname, $db_user , $db_pass) or die ("Could not connect to database.");
mysql_select_db($database, $conn) or die ("Could not select database.");
$query = "select UD.userName, UD.organizationName, count(distinct birdId) as nbOfKryss from UserData UD join LKryss LK on UD.userId = LK.userId group by UD.userName order by 3 desc";
$result = mysql_query($query) or die (mysql_error());
$i = 0;
while ($row = mysql_fetch_array($result)) {
$i++;
echo "";
echo "| ".$i;
echo " | ".$row["userName"];
echo " | ".$row["organizationName"];
echo " | ".$row["nbOfKryss"];
}
mysql_free_result($result);
echo "";
?>
|