<?php


$SpecimenNo = $_POST['formSpecimenNumber'];


$result1 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
         "       sptoolcollection.UnitID_Specimen, " .
         "       sptoolcollection.CollectionCode_Specimen, " .
         "       sptoolcollection.InstitutionCode_Specimen, " .
         "       sptoolcollection.Collectors, " . 
         "       sptoolcollection.CollectionDateMin, " . 
         "       sptoolcollection.CollectionDateMax, " . 
         "       sptoolcollection.CollectorsNo, " . 
         "       sptoolcollection.Locality_ID, " . 
         "       sptoolcollection.Region, " .
         "       sptoolcollection.Locality, " .
         "       sptoolcollection.AltitudeMin, " . 
         "       sptoolcollection.AltitudeMax, " . 
         "       sptoolcollection.AltitudeUnit, " .
         "       sptoolcollection.AltitudeAccuracyStatement, " .
         "       sptoolcollection.LongitudeMin, " .
         "       sptoolcollection.LatitudeMin, " . 
         "       sptoolcollection.GUID, " . 
         "       countryisocode.Country, " .
         "       countryisocode.IsoCode, " .
         "       seasandoceans.SeasAndOceans " .
         "  FROM sptoolcollection " .
         " LEFT JOIN countryisocode ON sptoolcollection.FK_Country = countryisocode.ID_Country " .
         " LEFT JOIN seasandoceans ON sptoolcollection.FK_SeasAndOceans = seasandoceans.ID_SeasAndOceans " .
         " WHERE sptoolcollection.UnitID_Specimen = '$SpecimenNo'");
         
while($row = mysqli_fetch_object($result1))
{ $ID_Collection = $row->ID_Collection;
  $sqlUnitID = addslashes($row->UnitID_Specimen);
  $sqlSourceName = addslashes($row->CollectionCode_Specimen);
  $sqlSourceInstitutionCode = addslashes($row->InstitutionCode_Specimen); 
  $sqlPersonName = addslashes($row->Collectors);
  $sqlCollectionDateMin = addslashes($row->CollectionDateMin);
  $sqlCollectionDateMax = addslashes($row->CollectionDateMax);
  $sqlCollectorsNo = addslashes($row->CollectorsNo);
  $sqlLocality = addslashes($row->Region." ".$row->Locality." ".$row->SeasAndOceans);
  $sqlCountryName = addslashes($row->Country);
  $sqlISO2 = addslashes($row->IsoCode);
  $Altitude = $row->AltitudeMin;
  if($row->AltitudeMax != "") {$Altitude .= " - ".$row->AltitudeMax; }
  $Altitude .= $row->AltitudeUnit;
  $sqlAltitude = addslashes($Altitude);
  $sqlLongitude = addslashes($row->LongitudeMin);
  $sqlLatitude = addslashes($row->LatitudeMin);
  $sqlUnitGUID = addslashes($row->GUID);
  
}
  
 $result2 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM sptooltaxa " .
         " WHERE FK_Collection = '$ID_Collection'"); 

 while($row = mysqli_fetch_object($result2))
 
 { $ID_TaxonIdentifieds[] = $row->ID_TaxonIdentified;
 $Identifications[] = $row->ID_TaxonIdentified;
 $sqlGenus[] = addslashes($row->Genus);
 $sqlSubgenus[] = addslashes($row->Subgenus);
 $sqlFirstEpithet[] = addslashes($row->SpecificEpithet);
 $sqlSecondEpithet[] = addslashes($row->InfrapsecificEpithet);
 $sqlRank[] = addslashes($row->Rank);
 $sqlNameAuthorYearString[] = addslashes($row->NameAuthorYear);
 $sqlPreferredIdentificationFlag[] = addslashes($row->PreferredFlag);
 
}   
  if($ID_TaxonIdentifieds != "") {
 foreach($ID_TaxonIdentifieds as $ID_TaxonIdentified)
 {
 $result3 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM sptoolhighertaxon " .
         " WHERE FK_TaxonIdentified = '$ID_TaxonIdentified'"); 
 while($row = mysqli_fetch_object($result3)) 
 {   
  $sqlHigherTaxon[] = addslashes($row->HigherTaxon);
  $HigherTaxa[] = addslashes($row->HigherTaxon); 
  $sqlHigherTaxonRank[] = addslashes($row->TaxonRank);
 
        }
 
     } }
  

?>