%d ORDER BY areas.area_ID ASC LIMIT 1",$area_ID); $rs_next_id = mysql_query($query_rs_next_id, $connDiatom2) or die(mysql_error()); if ($row_rs_next_id = mysql_fetch_assoc($rs_next_id)) $next_id = $row_rs_next_id['area_ID']; else $next_id = $index_IDs[0]; mysql_select_db($database_connDiatom2, $connDiatom2); $query_rs_sites = sprintf("SELECT sites.* FROM sites WHERE sites.area_ID='%d' ORDER BY sites.site_name ASC",$area_ID); $rs_sites = mysql_query($query_rs_sites, $connDiatom2) or die(mysql_error()); $row_rs_sites = mysql_fetch_assoc($rs_sites); $totalRows_rs_sites = mysql_num_rows($rs_sites); mysql_select_db($database_connDiatom2, $connDiatom2); $query_rs_taxa = sprintf("SELECT DISTINCT taxa.* FROM sites, sites_and_taxa, taxa WHERE sites.area_ID='%d' AND taxa.active_inactive='active' AND sites_and_taxa.site_ID=sites.site_ID AND sites_and_taxa.taxon_ID=taxa.taxon_ID ORDER BY taxa.taxon_name ASC",$area_ID); $rs_taxa = mysql_query($query_rs_taxa, $connDiatom2) or die(mysql_error()); $row_rs_taxa = mysql_fetch_assoc($rs_taxa); $totalRows_rs_taxa = mysql_num_rows($rs_taxa); ?> Area Summary :: Antarctic Freshwater Diatoms
 

Description

 

0) { // Show if recordset not empty ?>

Sites for

 

0) { // Show if recordset not empty ?>

Diatom taxa found in

See: Overview maps