get_val();
db_connect(); //establish connection with the database
$rs_query=mysql_query(("SELECT CATEGORY,COLOUR1,COLOUR2,COLOUR3,SYNONYM1,SYNONYM2,SYNONYM3,"
."ABBREV,DONOR_NAME,DONOR_NB,FEM_ACC_NB,MAL_ACC_NB,OTHER_NB1,OTHER_NB2,OTHER_NB3,NB_FEM_POP,"
."POLL_GROUP from Pass_Access WHERE CULT_NAME='".$cultname."'"
." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn);
$rs=mysql_fetch_array($rs_query);
?>
Cultivar Name
ACCESSION
DATA
SCIENTIFIC NAME | ||||
CATEGORY | $rsctg_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='CATEGORY' and CODE=".$rs["CATEGORY"]),$conn); $rsctg=mysql_fetch_array($rsctg_query); if (!($rsctg==0)) { ?> "> } else { ?> } ?> | |||
COLOUR | ||||
Colour1 $rsclr_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='COLOUR1' and CODE=".$rs["COLOUR1"]),$conn); $rsclr=mysql_fetch_array($rsclr_query); if (!($rsclr==0)) { ?> "> } else { ?> } ?> Colour2 $rsclr_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='COLOUR2' and CODE=".$rs["COLOUR2"]),$conn); $rsclr=mysql_fetch_array($rsclr_query); if (!($rsclr==0)) { ?> "> } else { ?> } ?> Colour3 $rsclr_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='COLOUR3' and CODE=".$rs["COLOUR3"]),$conn); $rsclr=mysql_fetch_array($rsclr_query); if (!($rsclr==0)) { ?> "> } else { ?> } ?> | ||||
CULTIVAR NAME |
||||
Synonym1 | if ($rs["SYNONYM1"]!="") { ?> } ELSE { ?> }?> | |||
Synonym2 | if ($rs["SYNONYM2"]!="") { ?> } ELSE { ?> } ?> | |||
Synonym3 | if ($rs["SYNONYM1"]!="") { ?> "> } else { ?> } ?> | |||
Accepted Abbreviation | "> | |||
Donor Name |
"> | Donor Number | "> | |
Female Parent Acc No. | "> | Male Parent Acc No. | "> | |
OTHER NUMBERS ASSOCIATED WITH THE ACCESSION | ||||
Other Number1 | "> | |||
Other Number2 | "> | |||
Other Number3 | "> | |||
No of Palms in the Female Parent Population |
"> $rsfem_query=mysql_query(("SELECT EX_FEM_POP,NB_FEM_SAM from Pass_Access WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rsfem=mysql_fetch_array($rsfem_query); $rstp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='EX_FEM_POP' and CODE=".$rsfem["EX_FEM_POP"]),$conn); $rstp=mysql_fetch_array($rstp_query); if (!($rstp==0)) { ?> "> } else { ?> } ?> | |||
Palms Represented by the Sample | "> | |||
No of Palms in the Male Parent Population | $rstp1_query=mysql_query(("SELECT EX_MAL_POP,NB_MAL_POP,NB_MAL_SAM,ACQ_DATE from Pass_Access WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rstp1=mysql_fetch_array($rstp1_query); $rstp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='EX_MAL_POP' and CODE=".$rstp1["EX_MAL_POP"]),$conn); $rstp=mysql_fetch_array($rstp_query); ?> "> if (!($rstp==0)) { ?> "> } else { ?> } ?> | |||
Palms Represented by the Sample | "> | |||
Acquisition Date | "> | |||
Pollination Group | $rstp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='POLL_GROUP' and CODE=".$rs["POLL_GROUP"]),$conn); $rstp=mysql_fetch_array($rstp_query); if (!($rstp==0)) { ?> "> } else { ?> } ?> | |||
Type of Material Received | $rs1_query=mysql_query(("SELECT TYPE_MAT from Pass_Access WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs1=mysql_fetch_array($rs1_query); $rs_mat_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='TYPE_MAT' and CODE=".$rs1["TYPE_MAT"]),$conn); $rs_mat=mysql_fetch_array($rs_mat_query); if (!($rs_mat==0)) { ?> "> } else { ?> } ?> | |||
Accession Size | $rs3_query=mysql_query(("SELECT ACC_SIZE,AC_SIZE_DT from Pass_Access WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs3=mysql_fetch_array($rs3_query); ?> "> | |||
Date of Last Inventory Counting | "> | |||
Type of Maintenance | $rs2_query=mysql_query(("SELECT TYPE_MAIN from Pass_Access WHERE CULT_NAME='".$cultname."'" ." and ACCESS_NB='".$acc."' and ABBREV='".$abbr."'"),$conn); $rs2=mysql_fetch_array($rs2_query); $rstp_query=mysql_query(("SELECT MODALITY from code where FIELD_NAME='TYPE_MAIN' and CODE=".$rs2["TYPE_MAIN"]),$conn); $rstp=mysql_fetch_array($rstp_query); if (!($rstp==0)) { ?> "> } else { ?> } ?> |