"; print ""; print ""; print "
"; print""; }//while }// mysql_num_rows!=0 print "
"; if(mysql_num_rows($result2) == 0) print "
Sorry, No Match Found
"; else { // DISPLAY A LIST OF PLANT NAMES while ($o = mysql_fetch_object($result2)) { print "
".$o->genus." ".$o->species."
"; exit; }//if pattern else if($_POST['match'] == 'exact') //EXACT MATCH { $q1 = "SELECT plant_id,genus,species,author FROM botmast WHERE genus = '$g[0]' and species = '$g[1]' ORDER BY genus, species "; $result2 = mysql_query ($q1,$link_id); if(mysql_num_rows($result2) == 0) print "
Sorry, No Match Found.. If you are not sure with the plant name, please use pattern match
"; else { while ($o = mysql_fetch_object($result2)) { //print "
Found : ".$o->plant_id." ".$o->genus." ".$o->species."
"; printTable($o->plant_id); exit; }//while }// mysql_num_rows!=0 }//else exact }//if user clicked GO else { //print_r($_GET); // AFTER USER CLICKS ON PLANT-NAME FROM THE LIST OF PLANTS FETCHED USING PLANTS, disp_id IS PASSED. if($_GET['disp_id']!="") { printTable($_GET['disp_id']); exit; } } // FORM $curform=new Html_form('bot_search.php','post','btname','','','chk_all',''); $curform->start(); ?> "; print "
"; //TABLE WITH INPUT BOX AND EXACT MATCH, PATTERN MATCH BUTTONS echo ""; print ""; echo ""; echo "
Enter Plant Name  "; $curform->displayText('gesp',$plantname,'30','100','1','',''); $curform->displaySubmit('go','go'); print "
"; print "Exact match  "; print " Pattern match "; print "
"; //DISPLAY ADV IMAGE print "
"; if($pid!=NULL) { print $pid; echo ""; //DISPLAY PLANT DETAILS. $pid IS THE PLANT ID printTable($pid); } // HTML BELOW IS THE FOOTER ?>
Disclaimer Privacy Copyright Contact Us Query Form Home

The site is best viewed in 800x600 pixels and IE 4 and above