<?php
include("db.inc.php");
include("html.inc.php");
// Get number of individuals
$query = "SELECT count(indkey) as indcount FROM gen_indiv";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$indcount = $row["indcount"];
//Get number of families
$query = "SELECT count(famkey) as famcount FROM gen_family";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$famcount = $row["famcount"];
//Get number of surnames
$query = "SELECT surname FROM gen_indiv GROUP BY surname";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$surcount = mysql_num_rows($result);
//Get number of notes
$query = "SELECT count(notekey) as notecount FROM gen_notes";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$notecount = $row["notecount"];
//Get number of master sources
$query = "SELECT count(srckey) as srccount FROM gen_source";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$srccount = $row["srccount"];
//Get number of source citations
$query = "SELECT * FROM gen_citation";
$result = mysql_query($query);
$scitecount = mysql_num_rows($result);
//Get number of facts
$query = "SELECT count(indfamkey) as factcount FROM gen_facts";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$factcount = $row["factcount"];
//Get number of births
$query = "SELECT count(indfamkey) as births FROM gen_facts WHERE type=\"Birth\"";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$births = $row["births"];
//Get number of deaths
$query = "SELECT count(indfamkey) as deaths FROM gen_facts WHERE type=\"Death\"";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$deaths = $row["deaths"];
//Get number of marriages
$query = "SELECT count(indfamkey) as marriages FROM gen_facts WHERE type=\"Marriage\"";
$result = mysql_query($query);
$row = mysql_fetch_array($result);
$marriages = $row["marriages"];
//Get number of other facts
$query = "SELECT indfamkey as other FROM gen_facts WHERE type != \"Marriage\" and type != \"Birth\" and type != \"Death\"";
$result = mysql_query($query);
$other = mysql_num_rows($result);
//Get number of images
$query = "SELECT id as imagecount FROM gen_images GROUP BY filename";
$result = mysql_query($query);
$imagecount = mysql_num_rows($result);
//Display statistics
open_table(array("cellpadding"=>"1","cellspacing"=>"0"));
open_row();
open_column(array("class"=>"n8","width"=>"150")); print "Individuals:"; close_column();
open_column(array("class"=>"n8")); print $indcount; close_column();
open_column(array("class"=>"n8","width"=>"50")); print " "; close_column();
open_column(array("class"=>"n8","width"=>"150")); print "Facts:"; close_column();
open_column(array("class"=>"n8")); print $factcount; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Families:"; close_column();
open_column(array("class"=>"n8")); print $famcount; close_column();
open_column(array("class"=>"n8")); print " "; close_column();
open_column(array("class"=>"n8")); print " Births:"; close_column();
open_column(array("class"=>"n8")); print $births; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Unique Surnames:"; close_column();
open_column(array("class"=>"n8")); print $surcount; close_column();
open_column(array("class"=>"n8")); print " "; close_column();
open_column(array("class"=>"n8")); print " Deaths:"; close_column();
open_column(array("class"=>"n8")); print $deaths; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Notes:"; close_column();
open_column(array("class"=>"n8")); print $notecount; close_column();
open_column(array("class"=>"n8")); print " "; close_column();
open_column(array("class"=>"n8")); print " Marriages:"; close_column();
open_column(array("class"=>"n8")); print $marriages; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Master Sources:"; close_column();
open_column(array("class"=>"n8")); print $srccount; close_column();
open_column(array("class"=>"n8")); print " "; close_column();
open_column(array("class"=>"n8")); print " Other:"; close_column();
open_column(array("class"=>"n8")); print $other; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Source Citations:"; close_column();
open_column(array("class"=>"n8")); print $scitecount; close_column();
close_row();
open_row();
open_column(array("class"=>"n8")); print "Photos/Images:"; close_column();
open_column(array("class"=>"n8")); print $imagecount; close_column();
close_row();
close_table();
?>
© 1999-2003 Keith Morrison, Infused Solutions
infused.org software - phpGene