if(strcmp($_POST["page"],"main")==0)
{
$cultname=$_POST["cultname"];
$acc=$_POST["acc"];
$abbr=$_POST["abbr"];
}
else
{
$cultname=$_GET["cultname"];
$acc=$_GET["acc"];
$abbr=$_GET["abbr"];
$page=$_GET["page"];
}
db_connect(); //establish connection with the database
?>
if($page=="1") { $rs_query=mysql_query(("SELECT COLL_INST,COLL_DATE,SITE_NB,COLL_NB,COUNTRY,PROVINCE,DEPT,COLL_SITE,COLL_LAT,COLL_LONG" ." from Pass_Collect WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs=mysql_fetch_array($rs_query); ?>
}
else if($page=="2")
{
$rs_query=mysql_query(("SELECT ORIGINE,GENERATION,AGE,COLL_SRCE,ADJ_ISOL,ADJ_TYPE"
." from Pass_Collect WHERE CULT_NAME='".$cultname."'"
." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn);
$rs=mysql_fetch_array($rs_query);
?>
}
else if($page=="3")
{
$rs_query=mysql_query(("SELECT COLL_PRO,SAMP_PRO,STAT_SAMP,APPEARANCE,POLLEN_SRC,EMBR_CULT,TISS_CULT,EX_SIZ_POP,"
."UN_SIZ_POP,ME_SAMPLE,POLLEN_WEI,CROP_SYST,CULT_STAT,LOC_NAME,LANG"
." from Pass_Collect WHERE CULT_NAME='".$cultname."'"
." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn);
$rs=mysql_fetch_array($rs_query);
?>
}
else if($page=="4")
{
$rs_query=mysql_query(("SELECT USE1,USE2,USE3,OTHER_CAR,OTHER_FREQ,CROWN"
." from Pass_Collect WHERE CULT_NAME='".$cultname."'"
." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn);
$rs=mysql_fetch_array($rs_query);
?>
}
?>
Cultivar Name
COLLECTION DATA
if($page=="1") { $rs_query=mysql_query(("SELECT COLL_INST,COLL_DATE,SITE_NB,COLL_NB,COUNTRY,PROVINCE,DEPT,COLL_SITE,COLL_LAT,COLL_LONG" ." from Pass_Collect WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs=mysql_fetch_array($rs_query); ?>
Collecting institute | "> | |||
Date of original sample | "> | |||
Site No | "> | |||
Collectors No. | "> | |||
Country of collection | "> | |||
Province/State | "> | |||
Department/Country | "> | |||
Collection site | ||||
Latitude of collection site | "> | |||
Longitude of collection site | "> |
PARENT POPULATION | |
Origin of sample | $rsorg_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='ORIGINE' and CODE=".$rs["ORIGINE"]),$conn); $rsorg=mysql_fetch_array($rsorg_query); if (!($rsorg==0)) { ?> "> } else { ?> } ?> |
Generation structure | $rsgen_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='GENERATION' and CODE=".$rs["GENERATION"]),$conn); $rsgen=mysql_fetch_array($rsgen_query); if (!($rsgen==0)) { ?> "> } else { ?> } ?> |
Age estimate of parent material | "> |
Collection source | $rssrc_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='COLL_SRCE' and CODE=".$rs["COLL_SRCE"]),$conn); $rssrc=mysql_fetch_array($rssrc_query); if (!($rssrc==0)) { ?> "> } else { ?> } ?> |
ADJACENT PALM STATUS | |
Proximity (Isolation) | $rs_is_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='ADJ_ISOL' and CODE=".$rs["ADJ_ISOL"]),$conn); $rs_is=mysql_fetch_array($rs_is_query); if (!($rs_is==0)) { ?> "> } else { ?> } ?> |
Type (if not isolated) | $rs_adj_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='ADJ_TYPE' and CODE=".$rs["ADJ_TYPE"]),$conn); $rs_adj=mysql_fetch_array($rs_adj_query); if (!($rs_adj==0)) { ?> "> } else { ?> } ?> |
COLLECTION PROCEDURE: $rs_coll_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='COLL_PRO' and CODE=".$rs["COLL_PRO"]),$conn); $rs_coll=mysql_fetch_array($rs_coll_query); if (!($rs_coll==0)) { ?> "> } else { ?> } ?> | |
Sampling procedure | $rs_samp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='SAMP_PRO' and CODE=".$rs["SAMP_PRO"]),$conn); $rs_samp=mysql_fetch_array($rs_samp_query); if (!($rs_samp==0)) { ?> "> } else { ?> } ?> |
Status of sample | $rs_stat_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='STAT_SAMP' and CODE=".$rs["STAT_SAMP"]),$conn); $rs_stat=mysql_fetch_array($rs_stat_query); if (!($rs_stat==0)) { ?> "> } else { ?> } ?> |
General appearance | $rs_app_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='APPEARANCE' and CODE=".$rs["APPEARANCE"]),$conn); $rs_app=mysql_fetch_array($rs_app_query); if (!($rs_app==0)) { ?> "> } else { ?> } ?> |
Pollen source | $rs_poll_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='POLLEN_SRC' and CODE=".$rs["POLLEN_SRC"]),$conn); $rs_poll=mysql_fetch_array($rs_poll_query); if (!($rs_poll==0)) { ?> "> } else { ?> } ?> |
Embryo culture status | $rs_embr_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='EMBR_CULT' and CODE=".$rs["EMBR_CULT"]),$conn); $rs_embr=mysql_fetch_array($rs_embr_query); if (!($rs_embr==0)) { ?> "> } else { ?> } ?> |
Tissue culture status | $rs_tiss_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='TISS_CULT' and CODE=".$rs["TISS_CULT"]),$conn); $rs_tiss=mysql_fetch_array($rs_tiss_query); if (!($rs_tiss==0)) { ?> "> } else { ?> } ?> |
Size of the population | $rs_ex_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='EX_SIZ_POP' and CODE=".$rs["EX_SIZ_POP"]),$conn); $rs_ex=mysql_fetch_array($rs_ex_query); if (!($rs_ex==0)) { ?> "> } else { ?> } ?> "> $rs_un_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='UN_SIZ_POP' and CODE=".$rs["UN_SIZ_POP"]),$conn); $rs_un=mysql_fetch_array($rs_un_query); if (!($rs_un==0)) { ?> "> } else { ?> } ?> |
Method used | $rs_me_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='ME_SAMPLE' and CODE=".$rs["ME_SAMPLE"]),$conn); $rs_me=mysql_fetch_array($rs_me_query); if (!($rs_me==0)) { ?> "> } else { ?> } ?> |
Total weight of pollen collected | "> |
Total number of seed nuts, palms or embryos collected | $rs1_query=mysql_query(("SELECT NB_SEEDNUT,EX_SAMPLE,DENSITY from Pass_Collect WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs1=mysql_fetch_array($rs1_query); ?> "> |
No of palms sampled in the population | $rs_sam_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='EX_SAMPLE' and CODE=".$rs1["EX_SAMPLE"]),$conn); $rs_sam=mysql_fetch_array($rs_sam_query); if (!($rs_sam==0)) { ?> "> } else { ?> } ?> "> |
Plant population density | "> |
Cropping system & associated flora | $rs_crop_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='CROP_SYST' and CODE=".$rs["CROP_SYST"]),$conn); $rs_crop=mysql_fetch_array($rs_crop_query); if (!($rs_crop==0)) { ?> "> } else { ?> } ?> |
Cultivation status | $rs_cult_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='CULT_STAT' and CODE=".$rs["CULT_STAT"]),$conn); $rs_cult=mysql_fetch_array($rs_cult_query); if (!($rs_cult==0)) { ?> "> } else { ?> } ?> |
Local/vernacular name | "> |
Language or ethnic group | "> |
USES OF THE SOURCE POPULATION | |
Use1 | $rs_us_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='USE1' and CODE=".$rs["USE1"]),$conn); $rs_us=mysql_fetch_array($rs_us_query); if (!($rs_us==0)) { ?> "> } else { ?> } ?> |
Use2 | $rs_us_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='USE2' and CODE=".$rs["USE2"]),$conn); $rs_us=mysql_fetch_array($rs_us_query); if (!($rs_us==0)) { ?> "> } else { ?> } ?> |
Use3 | $rs_us_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='USE3' and CODE=".$rs["USE3"]),$conn); $rs_us=mysql_fetch_array($rs_us_query); if (!($rs_us==0)) { ?> "> } else { ?> } ?> |
BOTANICAL CHARACTERISTICS | |
Frequency of spicata type | $rs2_query=mysql_query(("SELECT SPICATA,PLICATA,ANDROGENA,MAKAPUNO from Pass_Collect WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs2=mysql_fetch_array($rs2_query); $rs_sp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='SPICATA' and CODE=".$rs2["SPICATA"]),$conn); $rs_sp=mysql_fetch_array($rs_sp_query); if (!($rs_sp==0)) { ?> "> } else { ?> } ?> |
Frequency plicata type | $rs_pl_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='PLICATA' and CODE=".$rs2["PLICATA"]),$conn); $rs_pl=mysql_fetch_array($rs_pl_query); if (!($rs_pl==0)) { ?> "> } else { ?> } ?> |
Frequency of androgena type | $rs_ag_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='ANDROGENA' and CODE=".$rs2["ANDROGENA"]),$conn); $rs_ag=mysql_fetch_array($rs_ag_query); if (!($rs_ag==0)) { ?> "> } else { ?> } ?> |
Frequency of macapuno type | $rs_mk_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='MAKAPUNO' and CODE=".$rs2["MAKAPUNO"]),$conn); $rs_mk=mysql_fetch_array($rs_mk_query); if (!($rs_mk==0)) { ?> "> } else { ?> } ?> |
Other special character | "> |
Frequency | $rs_fq_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='OTHER_FREQ' and CODE=".$rs["OTHER_FREQ"]),$conn); $rs_fq=mysql_fetch_array($rs_fq_query); if (!($rs_fq==0)) { ?> "> } else { ?> } ?> |
Overall appearance/shape of crown of parent tree | $rs_cr_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='CROWN' and CODE=".$rs["CROWN"]),$conn); $rs_cr=mysql_fetch_array($rs_cr_query); if (!($rs_cr==0)) { ?> "> } else { ?> } ?> |