$dsname=$_GET["dsname"];
trim($dsname);
$dsname=preg_replace("/'/",'',$dsname);
// dataset description
$sqlm="select * from Linkage_markers where DS_name='".$dsname."'";
$rem=mysql_query($sqlm,$conn);
$num=mysql_num_rows($rem);
$sqlds="select * from Dataset_Description where DS_name='".$dsname."'";
$re_ds=mysql_query($sqlds,$conn);
$fds=mysql_fetch_row($re_ds);
echo "
Dataset Description";
echo "
Dataset Name: $dsname
";
echo "Species: $fds[1]
";
echo "Method: $fds[2]
";
echo "No. of Genomic Regions: $num
";
echo "Phenotype: $fds[4]
";
$paper=$fds[5]." PubMed";
echo "Publication: $paper
";
echo "Dataset Summary: $fds[6]";
// linkage region information
echo "
There are $num genomic regions in the linkage dataset. Click genomic region to view genes in the linkage region.";
echo "
";
echo "Dataset name (PMID) | Species | Chr | Marker1 | Marker1 LOD | Marker1 P value | Marker1 location (bp) | Marker2 | Marker2 LOD | Marker2 P value | Marker2 location (bp) | Genomic region (bp) | Phenotype |
";
while ($fdsm=mysql_fetch_row($rem)){
for ($i=0;$i$fdsm[0] | $fdsm[1] | $fdsm[2] | $fdsm[3] | $fdsm[4] | $fdsm[5] | $fdsm[6] | $fdsm[7] | $fdsm[8] | $fdsm[9] | $fdsm[10] | ";
echo "$fdsm[11] | ";
echo "$fdsm[12] |
";
}
echo "
";
?>