Your browser does not support script
//html_header('Search by Botanical Names'); echo "
Select the CITES listed species
"; echo ""; echo "
"; @mysql_select_db('frlhtenvis'); //$q1 = "select plant_id, genus,species,author from botmast where length(cites) > 0 order by genus, species"; $q1 = "SELECT botmast.plant_id, genus,species,author FROM botmast INNER JOIN envis_botmast ON botmast.plant_id = envis_botmast.plant_id WHERE length(cites) > 0 ORDER BY genus, species"; $result2 = mysql_query ($q1,$link_id) or die(mysql_error()); $tot = mysql_num_rows($result2); echo "
"; // ****** changes for advertisements ***** print "
"; print "
"; // ****** echo "
"; echo "
No. of species: $tot
"; echo "
"; echo ""; echo "
"; $s='selected'; echo "
"; while ($query_data = mysql_fetch_row($result2)) { if($query_data[0]==$pid) { echo "
$query_data[1] $query_data[2] $query_data[3]"; $sps=$query_data[1]." ".$query_data[2]." ".$query_data[3]; } else { echo "
$query_data[1] $query_data[2] $query_data[3]"; } echo "
"; } echo "
"; echo "
"; echo "
"; // ************ print "
"; print "
"; print "
"; print "
"; // *********** echo "
"; echo "
"; if($pid!=NULL) { echo ""; echo "
"; PRINT "
Plant species selected
"; PRINT "
$plantname
"; //echo "
Plant Species Selected
"; //echo "
$plantname
"; echo "
"; //echo "
"; echo "
"; echo "
"; echo "
"; printTable($pid); } ?>
Disclaimer
Privacy
Copyright
Contact Us
Query Form
Home
The site is best viewed in 800x600 pixels and IE 4 and above