include("titlebartop.html");
//GET NUMBER OF VIRUSES IN THE XTAL DATABASE
$rows = mysql_query("SELECT COUNT(*) from xtal_table");
$myrow=mysql_fetch_array($rows);
$num_of_entries=$myrow[0];
echo"Space Group Frequencies for $num_of_entries VIPER entries **";
include("titlebarbottom.html");
?>
Space Group
Sp. Group #
Crystal System
# of Crystals
$i=0;
$results = mysql_query("SELECT distinct Space_Group, spgr_num, cryst_sys from xtal_table ORDER by spgr_num");
while ($myrow = mysql_fetch_array($results)) {
$spgrp=$myrow["Space_Group"];
$spgr_num=$myrow["spgr_num"];
$cryst=$myrow["cryst_sys"];
$rows = mysql_query("SELECT COUNT(*) from xtal_table where Space_Group=\"$spgrp\"");
$myrow=mysql_fetch_array($rows);
$count=$myrow[0];
//set the background row color
if ($i==1) {$color = $colors[$i];$i=0;}
else {$color=$colors[$i];$i++;}
echo"