|
Briard Pedigree Finder Statistics
|
|
|
|
";
echo "- There are $count dogs in the Pedigree Finder
";
// last update
$last_update=last_update();
echo "- Last update: $last_update
";
echo " ";
?>
|
|
|
1 and dam>1)";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "
";
echo "- Parentage is known on $count dogs
";
// missing
$query="select count(dog_id) from dogs where (sire=0 or dam=0)";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- One or both parents is missing on $count dogs
";
// unknown
$query="select count(dog_id) from dogs where (sire=1 and dam=1)";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- Parentage is unknown on $count dogs
";
echo "(Dogs with parentage given as unknown were ";
echo "registered as having unknown parents.) ";
echo " ";
?>
|
|
|
";
echo "";
$rows=array();
for ($i=0; $i<$num_rows; $i++)
array_push($rows,mysql_fetch_array($result));
for ($i=$num_rows-1; $i>=0; $i--) {
$row=$rows[$i];
$gender=gender($row[sex]);
if ($gender=="")
$gender="unknown";
echo "| $gender: | ";
echo "$row[count] | ";
}
echo " ";
?>
|
|
|
";
echo "";
$other=0;
for ($i=0; $i<$num_rows; $i++) {
$row=mysql_fetch_array($result);
$color=color($row[color]);
if($color!="") {
echo "| $color: | ";
echo "$row[count] | ";
}
else
$other+=$row[count];
}
echo "| other or unknown: | ";
echo "$other | ";
echo " ";
?>
|
|
|
\"\" group by origin";
$result=mysql_query($query);
$num_rows=mysql_num_rows($result);
$count=$row[0];
echo "
";
echo "";
for ($i=0; $i<$num_rows; $i++) {
$row=mysql_fetch_array($result);
echo "| $row[origin]: | ";
echo "$row[count] | ";
}
echo " ";
$query="select count(dog_id) as count from dogs where origin=\"\"";
$result=mysql_query($query);
$num_rows=mysql_num_rows($result);
?>
|
|
Date of birth (by decade)
|
|
";
echo "";
$query="select floor(year(dob)/10) as decade,count(dog_id) as count from dogs where dob<>'0000-00-00' group by decade";
$result=mysql_query($query);
$num_rows=mysql_num_rows($result);
$row=mysql_fetch_array($result);
for ($i=1; $i<$num_rows-1; $i++) {
$row=mysql_fetch_array($result);
echo "| $row[decade]0 - $row[decade]9: | ";
echo "$row[count] | ";
}
$row=mysql_fetch_array($result);
echo "| $row[decade]0 - present: | ";
echo "$row[count] | ";
echo " ";
?>
|
|
|
\"\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "
";
echo "- Callname is known for $count dogs
";
// registration number
$query="select count(dog_id) from dogs where reg_num <> \"\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- One or more registration numbers are known for $count dogs
";
// breeder
$query="select count(dog_id) from dogs where breeder <> \"\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- Breeder is known for $count dogs
";
// owner
$query="select count(dog_id) from dogs where owner <> \"\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- Owner is known for $count dogs
";
// health
$query="select count(dog_id) from dogs where health <> \"\"";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$count=$row[0];
echo "- Health information is available for $count dogs
";
echo " ";
?>
|