| New Search. |
| Back to Hitlist |
NameAuthorYear;
$ID_TaxonIdentified = $row->ID_TaxonIdentified;
$Genus = $row->Genus;
$Subgenus = $row->Subgenus;
$SpecificEpithet = $row->SpecificEpithet;
$InfraspecificEpithet = $row->InfraspecificEpithet;
$Rank = $row->Rank;
$AuthorParenth = $row->AuthorParenth;
$YearParenth = $row->YearParenth;
$Author = $row->Author;
$Year = $row->Year;
$KindOfIdentification = $row->KindOfIdentification;
$Identifier = $row->Identifier;
$IdentificationDate = $row->IdentificationDate;
$IdentificationNotes = $row->IdentificationNotes;
$PreferredFlag = "Yes";
}
$result2a = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptooltaxa.NameAuthorYear, " .
" sptooltaxa.Genus, " .
" sptooltaxa.Subgenus, " .
" sptooltaxa.SpecificEpithet, " .
" sptooltaxa.Rank, " .
" sptooltaxa.InfraspecificEpithet, " .
" sptooltaxa.AuthorParenth, " .
" sptooltaxa.YearParenth, " .
" sptooltaxa.Author, " .
" sptooltaxa.Year, " .
" sptooltaxa.KindOfIdentification, " .
" sptooltaxa.Identifier, " .
" sptooltaxa.IdentificationDate, " .
" sptooltaxa.IdentificationNotes, " .
" sptooltaxa.PreferredFlag " .
" FROM sptoolcollection, sptooltaxa " .
" WHERE sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag != '1' " .
" AND (sptooltaxa.Synecology = '' " .
" OR sptooltaxa.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result2b = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptooltaxa.NameAuthorYear, " .
" sptooltaxa.Genus, " .
" sptooltaxa.Subgenus, " .
" sptooltaxa.SpecificEpithet, " .
" sptooltaxa.Rank, " .
" sptooltaxa.InfraspecificEpithet, " .
" sptooltaxa.AuthorParenth, " .
" sptooltaxa.YearParenth, " .
" sptooltaxa.Author, " .
" sptooltaxa.Year, " .
" sptooltaxa.KindOfIdentification, " .
" sptooltaxa.Identifier, " .
" sptooltaxa.IdentificationDate, " .
" sptooltaxa.IdentificationNotes, " .
" sptooltaxa.PreferredFlag, " .
" sptooltaxa.Created_When, " .
" sptooltaxa.Created_Who " .
" FROM sptoolcollection, sptooltaxa " .
" WHERE sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.Synecology = 'host' " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3a = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'regnum' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3b = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'phylum' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3c = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'classis' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3d = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'ordo' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3e = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'familia' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result3f = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptooltaxa.ID_TaxonIdentified, " .
" sptoolhighertaxon.HigherTaxon, " .
" sptoolhighertaxon.TaxonRank " .
" FROM sptoolcollection, sptooltaxa, sptoolhighertaxon " .
" WHERE sptoolhighertaxon.FK_TaxonIdentified = sptooltaxa.ID_TaxonIdentified " .
" AND sptooltaxa.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptooltaxa.PreferredFlag = '1' " .
" AND sptoolhighertaxon.TaxonRank = 'subfamilia' " .
" AND (sptoolhighertaxon.Synecology = '' " .
" OR sptoolhighertaxon.Synecology IS NULL) " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$result4 = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolcollection.ID_Collection, " .
" sptoolmeasurementorfact.Value, " .
" sptoolmeasurementorfact.Unit, " .
" sptoolmeasurementorfact.Parameter, " .
" sptoolmeasurementorfact.Method " .
" FROM sptoolcollection, sptoolecology " .
" WHERE sptoolmeasurementorfact.FK_Collection = sptoolcollection.ID_Collection " .
" AND sptoolcollection.ID_Collection = '$ID_Collection'");
$resultVoucherRef = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolreferences.ID_Reference, " .
" sptoolreferences.FK_Collection, " .
" sptoolreferences.FK_References, " .
" reference.ReferenceText, " .
" reference.ReferenceUrl, " .
" sptoolreferences.ReferenceDetail " .
" FROM sptoolreferences " .
" LEFT JOIN reference ON sptoolreferences.FK_References = reference.ID_References " .
" WHERE sptoolreferences.FK_Collection = $ID_Collection");
$resultMMSpecimen = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolmultimedia.FK_Collection, " .
" sptoolmultimedia.ID_Multimedia, " .
" sptoolmultimedia.File_Path, " .
" sptoolmultimedia.File_Type, " .
" sptoolmultimedia.File_Created_When, " .
" sptoolmultimedia.File_Created_Who, " .
" sptoolmultimedia.File_Comment, " .
" sptoolmultimedia.File_Context, " .
" sptoolmultimedia.File_Group, " .
" sptoolmultimedia.File_License " .
" FROM sptoolmultimedia " .
" WHERE sptoolmultimedia.File_Group = 'specimen' " .
" AND sptoolmultimedia.FK_Collection = '$ID_Collection' " .
" ORDER BY sptoolmultimedia.ID_Multimedia");
$resultMMSite = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT sptoolmultimedia.FK_Collection, " .
" sptoolmultimedia.ID_Multimedia, " .
" sptoolmultimedia.File_Path, " .
" sptoolmultimedia.File_Type, " .
" sptoolmultimedia.File_Created_When, " .
" sptoolmultimedia.File_Created_Who, " .
" sptoolmultimedia.File_Comment, " .
" sptoolmultimedia.File_Context, " .
" sptoolmultimedia.File_Group, " .
" sptoolmultimedia.File_License " .
" FROM sptoolmultimedia " .
" WHERE sptoolmultimedia.File_Group = 'site' " .
" AND sptoolmultimedia.FK_Collection = '$ID_Collection' " .
" ORDER BY sptoolmultimedia.ID_Multimedia");
while($row = mysqli_fetch_object($result1))
{
$ID = $row->ID_Collection;
$Sp_UnitID_Specimen = $row->UnitID_Specimen;
$Sp_InstitutionCode_Specimen = $row->InstitutionCode_Specimen;
$Sp_CollectionCode_Specimen = $row->CollectionCode_Specimen;
$BasisOfRecord = $row->FK_BasisOfRecord;
$KindOfUnit = $row->FK_KindOfUnit;
$PrepType = $row->FK_PrepType;
$AccessionNo = $row->AccessionNo;
$AccessionName = $row->AccessionName;
$PrepDate = $row->PrepDate;
$PrepStaff = $row->FK_PrepStaff;
$PrepMaterials = $row->PrepMaterials;
$PrepProcess = $row->PrepProcess;
$AcquiredFrom = $row->FK_AcquiredFrom;
$ExpeditionDetails = $row->ExpeditionDetails;
$BiogeoRegion = $row->FK_BiogeographicRegion;
$CountryName = $row->FK_Country;
$Region = $row->Region;
$Locality = $row->Locality;
$Locality_ID = $row->Locality_ID;
$SeasAndOceans = $row->FK_SeasAndOceans;
$AltitudeMin = $row->AltitudeMin;
$AltitudeMax = $row->AltitudeMax;
$AltitudeUnit = $row->AltitudeUnit;
$AltitudeRaw = $row->AltitudeRaw;
$AltitudeMethod = $row->AltitudeMethod;
$AltitudeAccuracy = $row->AltitudeAccuracyStatement;
$DepthMin = $row->DepthMin;
$DepthMax = $row->DepthMax;
$DepthUnit = $row->DepthUnit;
$DepthRaw = $row->DepthRaw;
$DepthMethod = $row->DepthMethod;
$DepthAccuracy = $row->DepthAccuracyStatement;
$CoordinatesAccuracy = $row->CoordinatesAccuracyStatement;
$CoordinatesError = $row->CoordinatesErrorDistance;
$LatitudeMin = $row->LatitudeMin;
$LatitudeMax = $row->LatitudeMax;
$LatitudeRaw = $row->LatitudeRaw;
$LongitudeMin = $row->LongitudeMin;
$LongitudeMax = $row->LongitudeMax;
$LongitudeRaw = $row->LongitudeRaw;
$GeoDatum = $row->GeodeticDatum;
$Collectors = $row->Collectors;
$Sp_CollectorsNo = $row->CollectorsNo;
$CollectionDateMin = substr($row->CollectionDateMin, 0, -9);
$CollectionDateMax = substr($row->CollectionDateMax, 0, -9);
$CollectionYear = $row->CollectionYear;
$CollectionMethod = $row->CollectionMethod;
$CollectionNotes = $row->CollectionNotes;
$Habitat = $row->Habitat;
$SoilTexture = $row->FK_SoilTexture;
$SoilpH = $row->FK_SoilpH;
$HabitatCode = $row->FK_HabitatCode;
$LandUseCode = $row->FK_LandUseCode;
$Slope = $row->FK_Slope;
$Aspect = $row->FK_Aspect;
$Type = $row->FK_Type;
$TypeDesignation = $row->TypeDesignation;
$Sex = $row->FK_Sex;
$GeoMethod = $row->FK_GeocodeMethod;
$LifeStage = $row->LifeStage;
$LifeForm = $row->LifeForm;
$EscapedCoordinates = $row->EscapedCoordinates;
$Permission = $row->Permission;
$BlockedForLoaning = $row->Blocked_For_Loaning;
$BlockedForPublishing = $row->Blocked_For_Publishing;
$BlockedUntil = $row->Blocked_Until;
$LoanConditions = $row->Loan_Conditions;
$Notes = $row->Notes;
$NotesInternal = $row->Notes_Internal;
$Created_Who = $row->Created_Who;
$Created_When = $row->Created_When;
$SampleGroup = $row->SampleGroup;
$GUID = $row->GUID;
$QualifierSeries = $row->Qualifier_Series;
$Series = $row->FK_Strat_Series;
$QualifierStage = $row->Qualifier_Stage;
$Stage = $row->FK_Strat_Stage;
$FossilZone = $row->FossilZone;
$Formation = $row->Formation;
$SectionDetails = $row->SectionDetails;
$SpecimenDetails = $row->SpecimenDetails;
$RelationToParent = $row->FK_RelationToParent;
$FK_ParentID_Collection = $row->FK_ParentID_Collection;
?>
";
if($SampleGroup == "MixedSample") { include("inputmixedspecimen.php"); }
else { include("inputspecimen.php"); }
" |
";
echo "";
// include ("../ajax/Ajax.html");
?>