count>0){
$page=isset($_GET['page'])?intval($_GET['page']):1;
$total=$db->count;
$num=5;
$pagenum=ceil($total/$num);
if($page>$pagenum){$page=$pagenum;}?>
get('genecrick',Array ($offset, $num));
$Vec_array = array(
"UT" => "pCMV3-untagged",
"NM" => "pCMV3-N-Myc",
"NO" => "pCMV3-N-OFPSpark",
"NH" => "pCMV3-N-His",
"NY" => "pCMV3-N-HA",
"NG" => "pCMV3-N-GFPSpark",
"NF" => "pCMV3-N-FLAG",
"CM" => "pCMV3-C-Myc",
"CO" => "pCMV3-C-OFPSpark",
"CH" => "pCMV3-C-His",
"CY" => "pCMV3-C-HA",
"CG" => "pCMV3-C-GFPSpark",
"CF" => "pCMV3-C-FLAG",
);
$Tag_array = array(
"UT" => "without any tag",
"NM" => "N terminal Myc tag",
"NO" => "N terminal OFP tag",
"NH" => "N terminal His tag",
"NY" => "N terminal HA tag",
"NG" => "N terminal GFP tag",
"NF" => "N terminal Flag tag",
"CM" => "C terminal Myc tag",
"CO" => "C terminal OFP tag",
"CH" => "C terminal His tag",
"CY" => "C terminal HA tag",
"CG" => "C terminal GFP tag",
"CF" => "C terminal Flag tag",
);
foreach($rows as $row) {
if($row['Species']=='Human'){$Catalog="HG".$row['Item'];}
elseif($row['Species']=='Mouse'){$Catalog="MG".$row['Item'];}
elseif($row['Species']=='Rabbit'){$Catalog="TG".$row['Item'];}
elseif($row['Species']=='Rat'){$Catalog="RG".$row['Item'];}
elseif($row['Species']=='Canine'){$Catalog="DG".$row['Item'];}
elseif(in_array($row['Species'],array('Rhesus','Cynomolgus','Marmoset'))){$Catalog="CG".$row['Item'];}
elseif($row['Species']=='Ferret'){$Catalog="FG".$row['Item'];}
else{$Catalog="VG".$row['Item'];}
foreach($Vec_array as $e => $t){
echo "
Catalog Number
{$Catalog}-{$e}
Size / Price
1Unit/Please inquiry
RefSeq
{$row['NCBI_RefSeq']}
Species
{$row['Species']}
";}}?>