No hits. Please verify your entry and selection of specimen database. ";} else { $result1 = mysql_query("SELECT tableofflinegathering.ID_Gathering, " . "tableofflinegathering.UnitID_Specimen, " . "tableofflinegathering.CollectionCode_Specimen, " . "tableofflinegathering.InstitutionCode_Specimen, " . "tableofflinegathering.ContinentOrOcean, " . "tableofflinegathering.CountryName, " . "tableofflinegathering.CountryISO2, " . "tableofflinegathering.SeasAndOceans, " . "tableofflinegathering.GatheringAgent, " . "tableofflinegathering.GatheringDate, " . "tableofflinegathering.GatheringNo, " . "tableofflinegathering.TitleLabel, " . "tableofflinegathering.ExpeditionDetails, " . "tableofflinegathering.Region, " . "tableofflinegathering.Locality, " . "tableofflinegathering.Biotope, " . "tableofflinegathering.Altitude, " . "tableofflinegathering.LongitudeDecimal, " . "tableofflinegathering.LatitudeDecimal, " . "tableofflinegathering.Protected, " . "tableofflinegathering.Admission, " . "tablesex.Sex, " . "tablebasisofrecordspecimen.BasisOfRecord_Specimen " . "FROM tableofflinegathering JOIN tmpOfflineIDs " . "LEFT JOIN tablesex ON tableofflinegathering.ID_Sex = tablesex.ID_Sex " . "LEFT JOIN tablebasisofrecordspecimen ON tableofflinegathering.ID_BasisOfRecord = tablebasisofrecordspecimen.ID_BasisOfRecord_Specimen " . "WHERE tableofflinegathering.ID_Gathering = tmpOfflineIDs.ID_Gathering"); $result2a = mysql_query("SELECT DISTINCT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_Taxonidentified, " . "tableofflinetaxa.Genus, " . "tableofflinetaxa.Subgenus, " . "tableofflinetaxa.FirstEpithet, " . "tableofflinetaxa.SecondEpithet, " . "tableofflinetaxa.Rank, " . "tableofflinetaxa.Author, " . "tableofflinetaxa.Year, " . "tableofflinetaxa.NameAuthorYear, " . "tableofflinetaxa.Identifier, " . "tableofflinetaxa.IdentificationDate, " . "tableofflinetaxa.PreferredFlag, " . "tableofflinetaxa.EntryNameFlag, " . "tableofflinetaxa.Notes " . // "tablespecimentype.SpecimenType " . "FROM tableofflinetaxa JOIN tmpOfflineIDs " . // "LEFT JOIN ON tablespecimentype ON tableofflinetaxa.ID_Type = tablespecimentype.ID_SpecimenType " . "WHERE tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering " . " AND tableofflinetaxa.PreferredFlag = '1' " . "ORDER BY tableofflinetaxa.NameAuthorYear"); $result2b = mysql_query("SELECT DISTINCT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_Taxonidentified, " . "tableofflinetaxa.Genus, " . "tableofflinetaxa.Subgenus, " . "tableofflinetaxa.FirstEpithet, " . "tableofflinetaxa.SecondEpithet, " . "tableofflinetaxa.Rank, " . "tableofflinetaxa.Author, " . "tableofflinetaxa.Year, " . "tableofflinetaxa.NameAuthorYear, " . "tableofflinetaxa.Identifier, " . "tableofflinetaxa.IdentificationDate, " . "tableofflinetaxa.PreferredFlag, " . "tableofflinetaxa.EntryNameFlag, " . "tableofflinetaxa.Notes " . "FROM tableofflinetaxa JOIN tmpOfflineIDs " . "WHERE tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering " . " AND tableofflinetaxa.PreferredFlag = '0'"); while($row = mysql_fetch_object($result2a)) { $tmp = "".$row->NameAuthorYear.""; $NameAuthorYear1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Identifier.""; $Identifier1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->IdentificationDate.""; $IdentificationDate1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Notes.""; $Notes1[$row->ID_Gathering] .= $tmp; } while($row = mysql_fetch_object($result2b)) { if(isset($NameAuthorYear[$row->ID_Gathering])) { $NameAuthorYear[$row->ID_Gathering] .= "
"; } else { $NameAuthorYear[$row->ID_Gathering] = ""; } if(isset($Identifier[$row->ID_Gathering])) { $Identifier[$row->ID_Gathering] .= "
"; } else { $Identifier[$row->ID_Gathering] = ""; } if(isset($IdentificationDate[$row->ID_Gathering])) { $IdentificationDate[$row->ID_Gathering] .= "
"; } else { $IdentificationDate[$row->ID_Gathering] = ""; } if(isset($Notes[$row->ID_Gathering])) { $Notes[$row->ID_Gathering] .= "
"; } else { $Notes[$row->ID_Gathering] = ""; } $tmp = "".$row->Identifier.""; $Identifier[$row->ID_Gathering] .= $tmp; $tmp = "".$row->IdentificationDate.""; $IdentificationDate[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Notes.""; $Notes[$row->ID_Gathering] .= $tmp; $tmp = "".$row->NameAuthorYear.""; $NameAuthorYear[$row->ID_Gathering] .= $tmp; } $result3a = mysql_query("SELECT DISTINCT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_TaxonIdentified, " . "tableofflinehighertaxon.ID_Taxa, " . "tableofflinehighertaxon.HigherTaxon as HigherTaxon1, " . "tableofflinehighertaxon.TaxonRank as TaxonRank1 " . "FROM tableofflinetaxa, tableofflinehighertaxon, tmpOfflineIDs " . "WHERE tableofflinehighertaxon.ID_Taxa = tableofflinetaxa.ID_TaxonIdentified " . " AND tableofflinetaxa.PreferredFlag = '1' " . " AND tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering "); $result3b = mysql_query("SELECT DISTINCT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_TaxonIdentified, " . "tableofflinehighertaxon.ID_Taxa, " . "tableofflinehighertaxon.HigherTaxon as HigherTaxon2, " . "tableofflinehighertaxon.TaxonRank as TaxonRank2 " . "FROM tableofflinetaxa, tableofflinehighertaxon, tmpOfflineIDs " . "WHERE tableofflinehighertaxon.ID_Taxa = tableofflinetaxa.ID_TaxonIdentified " . " AND tableofflinetaxa.PreferredFlag = '0' " . " AND tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering "); while($row = mysql_fetch_object($result3a)) { if(isset($HigherTaxon1[$row->ID_Gathering])) { $HigherTaxon1[$row->ID_Gathering].$TaxonRank1[$row->ID_Gathering] .= "
"; } else { $HigherTaxon1[$row->ID_Gathering] = ""; } $tmp = "".$row->HigherTaxon1." (".$row->TaxonRank1."); "; $HigherTaxon1[$row->ID_Gathering].$TaxonRank1[$row->ID_Gathering] .= $tmp; $Ausgabe1 .= $tmp; } while($row = mysql_fetch_object($result3b)) { if(isset($HigherTaxon2[$row->ID_Gathering])) { $HigherTaxon2[$row->ID_Gathering].$TaxonRank2[$row->ID_Gathering] .= "
"; } else { $HigherTaxon2[$row->ID_Gathering] = ""; } $tmp = "".$row->HigherTaxon2." (".$row->TaxonRank2."); "; $HigherTaxon2[$row->ID_Gathering].$TaxonRank2[$row->ID_Gathering] .= $tmp; $Ausgabe2 .= $tmp; } $result4 = mysql_query("SELECT tableofflineimages.ID_OfflineGathering, " . "tableofflineimages.ID_Images, " . "tableofflineimages.ImageLink " . "FROM tableofflineimages, tmpOfflineIDs " . "WHERE tableofflineimages.ID_OfflineGathering = tmpOfflineIDs.ID_Gathering"); while($row = mysql_fetch_object($result4)) { $Image = 'true'; if(isset($ImageLink[$row->ID_Gathering])) { $ImageLink[$row->ID_Gathering] .= "
"; } else { $ImageLink[$row->ID_Gathering] = ""; } $tmp = build_href1($row->ImageLink,"Link"); $ImageLink[$row->ID_Gathering] .= $tmp; } $gesamt = mysql_num_rows($result1); if($gesamt == 1) { while($row = mysql_fetch_object($result1)) { echo ""; echo "

Unit details:

"; echo ""; echo "

Prefered Taxon Name: ".$NameAuthorYear1[$row->ID_Gathering].""; echo "
Unit ID: ".$row->UnitID_Specimen.""; echo "
Basis of Record: ".$row->BasisOfRecord_Specimen.""; echo "

Institution Code: ".$row->InstitutionCode_Specimen.""; echo "
Collection Code: ".$row->CollectionCode_Specimen."

"; echo "

Identification(s):

"; echo ""; echo ""; echo ""; echo $Notes1[$row->ID_Gathering] ? "" : ""; echo $Ausgabe1 ? "" : ""; echo $NameAuthorYear[$row->ID_Gathering] ? "" : ""; echo $Identifier[$row->ID_Gathering] ? "" : ""; echo $IdentificationDate[$row->ID_Gathering] ? "" : ""; echo $Notes[$row->ID_Gathering] ? "" : ""; echo $Ausgabe2 ? "" : ""; echo "

Name:	" . $NameAuthorYear1[$row->ID_Gathering]. "
Identifier:	" . $Identifier1[$row->ID_Gathering]. "
Date:	" . $IdentificationDate1[$row->ID_Gathering]. "
Notes:	" . $Notes1[$row->ID_Gathering]. "
Taxonomy:	" . $Ausgabe1 . "
Name:	" . $NameAuthorYear[$row->ID_Gathering]. "
Identifier:	" . $Identifier[$row->ID_Gathering]. "
Date:	" . $IdentificationDate[$row->ID_Gathering]. "
Notes:	" . $Notes[$row->ID_Gathering]. "
Taxonomy:	" . $Ausgabe2 . "

"; if($Image = 'true') { echo "

Multimedia:

".$ImageLink[$row->ID_Gathering]."

"; } echo "

Gathering:

"; echo ""; echo $row->ContinentOrOcean ? "" : ""; echo $row->CountryName ? "" : ""; echo $row->SeasAndOceans ? "" : ""; echo $row->GatheringAgent ? "" : ""; echo $row->Altitude ? "" : ""; echo ""; echo $row->Region ? "" : "" : ""; echo ""; echo $row->Locality ? "" : ""; echo $row->GatheringDate ? "" : ""; echo ""; echo $row->LatitudeDecimal || $row->LongitudeDecimal ? "" : ""; echo $row->GatheringNo ? "" : ""; echo $row->TitleLabel || $row->ExpedtionDetails ? "" : ""; echo ""; echo ""; echo "

"; echo "

Locality:	Collector(s):	Other info:
Continent/Ocean: ".$row->ContinentOrOcean."

Country: ".$row->CountryName." (".$row->CountryISO2.")

Sea: ".$row->SeasAndOceans."
	".$row->GatheringAgent."		Altitude: ".$row->Altitude."
Region: ".$row->Region."
"; echo $row->Biotope ? "		Biotope: ".$row->Biotope."
Locality: ".$row->Locality."
		Date: ".$row->GatheringDate."
Coordinates: ".$row->LatitudeDecimal." \| ".$row->LongitudeDecimal."
	Collection No: ".$row->GatheringNo."		Project: ".$row->TitleLabel." (".$row->ExpeditionDetails.")
Notes: Specimen data not accessible via wrapper!

"; } } if($gesamt > 1) { echo "".$gesamt." entries found! Please select a specimen or verify your entry!"; //$Offlinecount=0; if($formAddLimits == '1') { echo "

Data with existing DNA sample only! To see all hits without search limits press 'Verify' again!"; } if($formAddLimits == '2') { echo "

Data without existing DNA sample only! To see all hits without search limits press 'Verify' again!"; } if($formAddLimits == '' ) { echo "
Please press 'Verify' again!"; } for ($i=1; $i<=$gesamt; $i++) { $row=mysql_fetch_array($result1); { $Offlinecount++; // while($row = mysql_fetch_object($result1)) // { echo ""; echo "

"; echo ""; echo "

".$i.". Unit details:

"; echo "

Prefered Taxon Name: ".$NameAuthorYear1[$row['ID_Gathering']]." ".$TaxonRank1[$row['ID_Gathering']]; echo " ".$NameAuthorYear[$row['ID_Gathering']]." ".$TaxonRank2[$row['ID_Gathering']]; echo $Notes1[$row['ID_Gathering']] ? " Notes: " . $Notes1[$row['ID_Gathering']] : ""; echo "
Unit ID: ".$row['UnitID_Specimen']." "; echo "Institution Code: ".$row['InstitutionCode_Specimen']." "; echo "Collection Code: ".$row['CollectionCode_Specimen']."

"; if($Image = 'true') { echo "

Multimedia2:

".$ImageLink[$row->ID_Gathering]."

"; } echo ""; echo ""; echo $row['ContinentOrOcean'] ? "" : ""; echo $row['CountryName'] ? "" : ""; echo $row['SeasAndOceans'] ? "" : ""; echo $row['GatheringAgent'] ? "" : ""; echo $row['Altitude'] ? "" : ""; echo ""; echo $row['Region'] ? "" : "" : ""; echo ""; echo $row['Locality'] ? "" : ""; echo $row['GatheringDate'] ? "" : ""; echo ""; echo $row['LatitudeDecimal'] || $row['LongitudeDecimal'] ? "" : ""; echo $row['GatheringNo'] ? "" : ""; echo $row['TitleLabel'] || $row['ExpedtionDetails'] ? "" : ""; echo ""; echo ""; echo ""; echo "

Locality:	Collector(s):	Other info:
Continent/Ocean: ".$row['ContinentOrOcean']."

Country: ".$row['CountryName']." (".$row['CountryISO2'].")

Sea: ".$row['SeasAndOceans']."
	".$row['GatheringAgent']."		Altitude: ".$row['Altitude']."
Region: ".$row['Region']."
"; echo $row['Biotope'] ? "		Biotope: ".$row['Biotope']."
Locality: ".$row['Locality']."
		Date: ".$row['GatheringDate']."
Coordinates: ".$row['LatitudeDecimal']." \| ".$row['LongitudeDecimal']."
	Collection No: ".$row['GatheringNo']."		Project: ".$row['TitleLabel']." (".$row['ExpeditionDetails'].")
Notes: Specimen data not accessible via wrapper!

"; }} }} } //if (!empty($sql)) } $variable5 = $_POST['formTest']; if($variable5 != "" and !$formSubmitVerify and !$formSubmitSave) { $mykey = key($variable5); $sqlcreate = "CREATE TEMPORARY TABLE tmpOfflineIDs TYPE=HEAP "; $sql = $sqlcreate . $sql = "SELECT DISTINCT ID_Gathering FROM tableofflinegathering WHERE ID_Gathering = '$mykey'"; $Offlinecount=0; if(!empty($sql)) { // just in case it is still here: drop tmpTitleIDs mysql_query("DROP TABLE IF EXISTS tmpOfflineIDs"); // create new table with title IDs mysql_query($sql); if(!mysql_affected_rows()) { echo "No hits. Please verify your entry and selection of specimen database. ";} else { $result1 = mysql_query("SELECT tableofflinegathering.ID_Gathering, " . "tableofflinegathering.UnitID_Specimen, " . "tableofflinegathering.CollectionCode_Specimen, " . "tableofflinegathering.InstitutionCode_Specimen, " . "tableofflinegathering.ContinentOrOcean, " . "tableofflinegathering.CountryName, " . "tableofflinegathering.CountryISO2, " . "tableofflinegathering.SeasAndOceans, " . "tableofflinegathering.GatheringAgent, " . "tableofflinegathering.GatheringDate, " . "tableofflinegathering.GatheringNo, " . "tableofflinegathering.TitleLabel, " . "tableofflinegathering.ExpeditionDetails, " . "tableofflinegathering.Region, " . "tableofflinegathering.Locality, " . "tableofflinegathering.Biotope, " . "tableofflinegathering.Altitude, " . "tableofflinegathering.LongitudeDecimal, " . "tableofflinegathering.LatitudeDecimal, " . "tableofflinegathering.Protected, " . "tableofflinegathering.Admission, " . "tablesex.Sex, " . "tablebasisofrecordspecimen.BasisOfRecord_Specimen " . "FROM tableofflinegathering JOIN tmpOfflineIDs " . "LEFT JOIN tablesex ON tableofflinegathering.ID_Sex = tablesex.ID_Sex " . "LEFT JOIN tablebasisofrecordspecimen ON tableofflinegathering.ID_BasisOfRecord = tablebasisofrecordspecimen.ID_BasisOfRecord_Specimen " . "WHERE tableofflinegathering.ID_Gathering = tmpOfflineIDs.ID_Gathering"); $result2a = mysql_query("SELECT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_Taxonidentified, " . "tableofflinetaxa.Genus, " . "tableofflinetaxa.Subgenus, " . "tableofflinetaxa.FirstEpithet, " . "tableofflinetaxa.SecondEpithet, " . "tableofflinetaxa.Rank, " . "tableofflinetaxa.Author, " . "tableofflinetaxa.Year, " . "tableofflinetaxa.NameAuthorYear, " . "tableofflinetaxa.Identifier, " . "tableofflinetaxa.IdentificationDate, " . "tableofflinetaxa.PreferredFlag, " . "tableofflinetaxa.EntryNameFlag, " . "tableofflinetaxa.Notes " . // "tablespecimentype.SpecimenType " . "FROM tableofflinetaxa JOIN tmpOfflineIDs " . // "LEFT JOIN ON tablespecimentype ON tableofflinetaxa.ID_Type = tablespecimentype.ID_SpecimenType " . "WHERE tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering " . " AND tableofflinetaxa.PreferredFlag = '1'"); $result2b = mysql_query("SELECT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_Taxonidentified, " . "tableofflinetaxa.Genus, " . "tableofflinetaxa.Subgenus, " . "tableofflinetaxa.FirstEpithet, " . "tableofflinetaxa.SecondEpithet, " . "tableofflinetaxa.Rank, " . "tableofflinetaxa.Author, " . "tableofflinetaxa.Year, " . "tableofflinetaxa.NameAuthorYear, " . "tableofflinetaxa.Identifier, " . "tableofflinetaxa.IdentificationDate, " . "tableofflinetaxa.PreferredFlag, " . "tableofflinetaxa.EntryNameFlag, " . "tableofflinetaxa.Notes " . "FROM tableofflinetaxa JOIN tmpOfflineIDs " . "WHERE tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering " . " AND tableofflinetaxa.PreferredFlag = '0'"); while($row = mysql_fetch_object($result2a)) { $tmp = "".$row->NameAuthorYear.""; $NameAuthorYear1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Identifier.""; $Identifier1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->IdentificationDate.""; $IdentificationDate1[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Notes.""; $Notes1[$row->ID_Gathering] .= $tmp; } while($row = mysql_fetch_object($result2b)) { if(isset($NameAuthorYear[$row->ID_Gathering])) { $NameAuthorYear[$row->ID_Gathering] .= "
"; } else { $NameAuthorYear[$row->ID_Gathering] = ""; } if(isset($Identifier[$row->ID_Gathering])) { $Identifier[$row->ID_Gathering] .= "
"; } else { $Identifier[$row->ID_Gathering] = ""; } if(isset($IdentificationDate[$row->ID_Gathering])) { $IdentificationDate[$row->ID_Gathering] .= "
"; } else { $IdentificationDate[$row->ID_Gathering] = ""; } if(isset($Notes[$row->ID_Gathering])) { $Notes[$row->ID_Gathering] .= "
"; } else { $Notes[$row->ID_Gathering] = ""; } $tmp = "".$row->Identifier.""; $Identifier[$row->ID_Gathering] .= $tmp; $tmp = "".$row->IdentificationDate.""; $IdentificationDate[$row->ID_Gathering] .= $tmp; $tmp = "".$row->Notes.""; $Notes[$row->ID_Gathering] .= $tmp; $tmp = "".$row->NameAuthorYear.""; $NameAuthorYear[$row->ID_Gathering] .= $tmp; } $result3a = mysql_query("SELECT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_TaxonIdentified, " . "tableofflinehighertaxon.ID_Taxa, " . "tableofflinehighertaxon.HigherTaxon, " . "tableofflinehighertaxon.TaxonRank " . "FROM tableofflinetaxa, tableofflinehighertaxon, tmpOfflineIDs " . "WHERE tableofflinehighertaxon.ID_Taxa = tableofflinetaxa.ID_TaxonIdentified " . " AND tableofflinetaxa.PreferredFlag = '1' " . " AND tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering "); $result3b = mysql_query("SELECT tableofflinetaxa.ID_Gathering, " . "tableofflinetaxa.ID_TaxonIdentified, " . "tableofflinehighertaxon.ID_Taxa, " . "tableofflinehighertaxon.HigherTaxon, " . "tableofflinehighertaxon.TaxonRank " . "FROM tableofflinetaxa, tableofflinehighertaxon, tmpOfflineIDs " . "WHERE tableofflinehighertaxon.ID_Taxa = tableofflinetaxa.ID_TaxonIdentified " . " AND tableofflinetaxa.PreferredFlag = '0' " . " AND tableofflinetaxa.ID_Gathering = tmpOfflineIDs.ID_Gathering "); while($row = mysql_fetch_object($result3a)) { if(isset($HigherTaxon[$row->ID_Gathering])) { $HigherTaxon[$row->ID_Gathering].$TaxonRank[$row->ID_Gathering] .= "
"; } else { $HigherTaxon[$row->ID_Gathering] = ""; } $tmp = "".$row->HigherTaxon." (".$row->TaxonRank."); "; $HigherTaxon[$row->ID_Gathering].$TaxonRank[$row->ID_Gathering] .= $tmp; $Ausgabe1 .= $tmp; } while($row = mysql_fetch_object($result3b)) { if(isset($HigherTaxon[$row->ID_Gathering])) { $HigherTaxon[$row->ID_Gathering].$TaxonRank[$row->ID_Gathering] .= "
"; } else { $HigherTaxon[$row->ID_Gathering] = ""; } $tmp = "".$row->HigherTaxon." (".$row->TaxonRank."); "; $HigherTaxon[$row->ID_Gathering].$TaxonRank[$row->ID_Gathering] .= $tmp; $Ausgabe2 .= $tmp; } $result4 = mysql_query("SELECT tableofflineimages.ID_Images, " . "tableofflineimages.ID_OfflineGathering, " . "tableofflineimages.ImageLink " . "FROM tableofflineimages JOIN tmpOfflineIDs " . "WHERE tableofflineimages.ID_OfflineGathering = tmpOfflineIDs.ID_Gathering"); while($row = mysql_fetch_object($result4)) {if(isset($ImageLink[$row->ID_OfflineGathering])) { $ImageLink .= build_href1($row->ImageLink,$row->ImageLink) . "
"; } else { $ImageLink .= build_href1($row->ImageLink,$row->ImageLink) . "
";} } while($row = mysql_fetch_object($result1)) { echo ""; echo "

Unit details:

"; echo ""; echo "

Prefered Taxon Name: ".$NameAuthorYear1[$row->ID_Gathering].""; echo "
Unit ID: ".$row->UnitID_Specimen.""; echo "
Basis of Record: ".$row->BasisOfRecord_Specimen.""; echo "

Institution Code: ".$row->InstitutionCode_Specimen.""; echo "
Collection Code: ".$row->CollectionCode_Specimen."

"; echo "

Identification(s):

"; echo ""; echo ""; echo ""; echo $Ausgabe1 ? "" : ""; echo $NameAuthorYear[$row->ID_Gathering] ? "" : ""; echo $Identifier[$row->ID_Gathering] ? "" : ""; echo $IdentificationDate[$row->ID_Gathering] ? "" : ""; echo $Notes[$row->ID_Gathering] ? "" : ""; echo $Ausgabe2 ? "" : ""; echo "

Name:	" . $NameAuthorYear1[$row->ID_Gathering]. "
Identifier:	" . $Identifier1[$row->ID_Gathering]. "
Date:	" . $IdentificationDate1[$row->ID_Gathering]. "
Taxonomy:	" . $Ausgabe1 . "
Name:	" . $NameAuthorYear[$row->ID_Gathering]. "
Identifier:	" . $Identifier[$row->ID_Gathering]. "
Date:	" . $IdentificationDate[$row->ID_Gathering]. "
Date:	" . $Notes[$row->ID_Gathering]. "
Taxonomy:	" . $Ausgabe2 . "

"; echo $ImageLink ? "

Multimedia:

".$ImageLink."

" : ""; echo "

Gathering:

"; echo "

Locality:	Collector(s):	Other info:
Continent/Ocean: ".$row->ContinentOrOcean."

Country: ".$row->CountryName." (".$row->CountryISO2.")

Sea/Ocean: ".$row->SeasAndOceans."
	".$row->GatheringAgent."		Altitude: ".$row->Altitude."
Region: ".$row->Region."
"; echo $row->Biotope ? "		Biotope: ".$row->Biotope."
Locality: ".$row->Locality."
		Date: ".$row->GatheringDate."
Coordinates: ".$row->LatitudeDecimal." \| ".$row->LongitudeDecimal."
	Collection No: ".$row->GatheringNo."		Project: ".$row->TitleLabel." (".$row->ExpeditionDetails.")
Notes: Specimen data not accessible via wrapper!

"; } }} } //if (!empty($sql)) ?>