Select the vernacular language and name"; echo ""; echo "
"; //$link_id = mysql_connect('localhost', 'karthik', ''); @mysql_select_db('frlhtenvis'); if($_POST['ara']=='AR'){$ar='checked'; $vernam.='Arabic'.', ';} if($_POST['eng']=='EN'){$en='checked'; $vernam.='English'.', ';} if($_POST['hin']=='HI'){$hi='checked'; $vernam.='Hindi'.', ';} if($_POST['hom']=='HO'){$ho='checked'; $vernam.='Homeo'.', ';} if($_POST['kan']=='KA'){$ka='checked'; $vernam.='Kannada'.', ';} if($_POST['mal']=='MA'){$ma='checked'; $vernam.='Malayalam'.', ';} if($_POST['mar']=='MR'){$mr='checked'; $vernam.='Marathi'.', ';} if($_POST['per']=='PR'){$pe='checked'; $vernam.='Persian'.', ';} if($_POST['san']=='SK'){$sa='checked'; $vernam.='Sanskrit'.', ';} if($_POST['tam']=='TA'){$ta='checked'; $vernam.='Tamil'.', ';} if($_POST['tel']=='TE'){$te='checked'; $vernam.='Telugu'.', ';} if($_POST['tib']=='TI'){$ti='checked'; $vernam.='Tibetan'.', ';} if($_POST['urd']=='UR'){$ur='checked'; $vernam.='Urdu'.', ';} if($_POST['cah']=='CA'){$ca='checked';$ar='checked';$en='checked';$hi='checked'; $ho='checked';$ka='checked';$ma='checked';$mr='checked';$pe='checked'; $sa='checked';$ta='checked';$te='checked';$ti='checked';$ur='checked';} $vernam = remove_last(trim($vernam)); $findpos=strrpos($vernam, ","); if($findpos>=1) $vernam=substr_replace($vernam," and", $findpos,1); // MAIN TABLE echo ""; echo ""; //print_r($_POST); /*if($_POST['ara']!=NULL||$_POST['eng']!=NULL||$_POST['hin']!=NULL||$_POST['hom']!=NULL||$_POST['kan']!=NULL||$_POST['mal']!=NULL||$_POST['mar']!=NULL||$_POST['per']!=NULL ||$_POST['san']!=NULL|| $_POST['tam']!=NULL|| $_POST['tel']!=NULL|| $_POST['tib']!=NULL||$_POST['urd']!=NULL) {*/ $s='selected'; $q = "select distinct name from nomen_co where ("; if($_POST['ara']!=NULL) $qtemp.="lang_id='".$_POST['ara']."'||"; else $qtemp.=""; if($_POST['eng']!=NULL) $qtemp.="lang_id='".$_POST['eng']."'||"; else $qtemp.=""; if($_POST['hin']!=NULL) $qtemp.="lang_id='".$_POST['hin']."'||"; else $qtemp.=""; if($_POST['hom']!=NULL) $qtemp.="lang_id='".$_POST['hom']."'||"; else $qtemp.=""; if($_POST['kan']!=NULL) $qtemp.="lang_id='".$_POST['kan']."'||"; else $qtemp.=""; if($_POST['mal']!=NULL) $qtemp.="lang_id='".$_POST['mal']."'||"; else $qtemp.=""; if($_POST['mar']!=NULL) $qtemp.="lang_id='".$_POST['mar']."'||"; else $qtemp.=""; if($_POST['per']!=NULL) $qtemp.="lang_id='".$_POST['per']."'||"; else $qtemp.=""; if($_POST['san']!=NULL) $qtemp.="lang_id='".$_POST['san']."'||"; else $qtemp.=""; if($_POST['tam']!=NULL) $qtemp.="lang_id='".$_POST['tam']."'||"; else $qtemp.=""; if($_POST['tel']!=NULL) $qtemp.="lang_id='".$_POST['tel']."'||"; else $qtemp.=""; if($_POST['tib']!=NULL) $qtemp.="lang_id='".$_POST['tib']."'||"; else $qtemp.=""; if($_POST['urd']!=NULL) $qtemp.="lang_id='".$_POST['urd']."'||"; else $qtemp.=""; $qend=") order by name"; //$qend=") order by name limit 0,300"; $qtemp=remove_last(trim($qtemp)); $qtemp=remove_last(trim($qtemp)); /*$qtempfull=$qtemp.$qend; $q.=$qtempfull; $quer =mysql_query($q,$link_id); $tot = mysql_num_rows($quer);*/ //} //DISPLAY TEXT BOX AND EXACT MATCH , PATTERN MATCH BUTTONS echo ""; echo "
"; //TABLE WITH CHECKBOXES FOR LANGUAGE NAMES echo ""; echo " "; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo ""; echo " "; echo " "; echo " "; echo "
Arabic English Hindi
Homeopathy Kannada Malayalam
Marathi Persian Sanskrit
Tamil Telugu Tibetan
Urdu Check All
"; echo "		"; echo ""; echo ""; echo ""; echo ""; /*print "";*/ echo "
"; echo "No.  of  Vernacular Names :  $tot

Exact match  "; print " Pattern match "; print ""; print "
"; //DISPLAY ADV IMAGE print "
"; echo "
"; if ($lst_vername!=NULL) { //print "reached here"; $q1 = "select distinct plant_id from nomen_co where ("; $q1end=") && name='$lst_vername' order by plant_id"; /*if($_POST['match'] == "exact" ) { $q1 = "select distinct plant_id from nomen_co where ("; $q1end=") && name='$lst_vername' order by plant_id"; } else if($_POST['match'] == "pattern" ) { $q1 = "select distinct plant_id from nomen_co where ("; $q1end=") && name like '%$lst_vername%' order by plant_id"; }*/ $q1tempfull=$qtemp.$q1end; $q1.=$q1tempfull; //print "query is : $q1"; $quer1 =mysql_query($q1,$link_id); $tot1 = mysql_num_rows($quer1); if($tot1 == 0) print "
No records found for '$lst_vername' !
"; if($tot1>1) { //print $tot1; $ah_q1 = "select distinct plant_id from nomen_co where ("; if($_POST['ara']!=NULL) $ah_q1temp.="lang_id='".$_POST['cara']."'||"; else $ah_q1temp.=""; if($_POST['eng']!=NULL) $ah_q1temp.="lang_id='".$_POST['eng']."'||"; else $ah_q1temp.=""; if($_POST['hin']!=NULL) $ah_q1temp.="lang_id='".$_POST['hin']."'||"; else $ah_q1temp.=""; if($_POST['hom']!=NULL) $ah_q1temp.="lang_id='".$_POST['hom']."'||"; else $ah_q1temp.=""; if($_POST['kan']!=NULL) $ah_q1temp.="lang_id='".$_POST['kan']."'||"; else $ah_q1temp.=""; if($_POST['mal']!=NULL) $ah_q1temp.="lang_id='".$_POST['mal']."'||"; else $ah_q1temp.=""; if($_POST['mar']!=NULL) $ah_q1temp.="lang_id='".$_POST['mar']."'||"; else $ah_q1temp.=""; if($_POST['per']!=NULL) $ah_q1temp.="lang_id='".$_POST['per']."'||"; else $ah_q1temp.=""; if($_POST['san']!=NULL) $ah_q1temp.="lang_id='".$_POST['san']."'||"; else $ah_q1temp.=""; if($_POST['tam']!=NULL) $ah_q1temp.="lang_id='".$_POST['tam']."'||"; else $ah_q1temp.=""; if($_POST['tel']!=NULL) $ah_q1temp.="lang_id='".$_POST['tel']."'||"; else $ah_q1temp.=""; if($_POST['tib']!=NULL) $ah_q1temp.="lang_id='".$_POST['tib']."'||"; else $ah_q1temp.=""; if($_POST['urd']!=NULL) $ah_q1temp.="lang_id='".$_POST['urd']."'||"; else $ah_q1temp.=""; $ah_q1end=") && name='$lst_vername' order by plant_id"; $ah_q1temp=remove_last(trim($ah_q1temp)); $ah_q1temp=remove_last(trim($ah_q1temp)); $ah_q1temp.=$ah_q1end; $ah_q1.=$ah_q1temp; $ah_q1_res = mysql_query($ah_q1,$link_id); echo "
"; echo ""; echo ""; echo ""; echo "
"; $count=1; while($ahref=mysql_fetch_row($ah_q1_res)) { $aplid=$ahref[0]; $botname_query = "select distinct b.family , b.genus, b.species, b.author, b.variety, b.s_species, b.dpt_ref, b.red_status, d.distri from botmast b, dist d where (b.plant_id = $aplid and b.plant_id = d.plant_id)"; $botname_query_res = mysql_query($botname_query,$link_id); while($temp_botname_query = mysql_fetch_row($botname_query_res)) { //echo "$temp_botname_query[1] $temp_botname_query[2] $temp_botname_query[3]"; if(($count % 2)==0) { echo "
"; } else { echo ""; } $count++; } } echo "
"; echo "
"; //echo "
"; } while($temp_plid = mysql_fetch_row($quer1)) { $plid=$temp_plid[0]; echo ""; echo ""; echo ""; //echo ""; echo "
Language selected : $vernam
$vernam
"; //echo "
"; echo "
"; printTable($plid); } } ?>
Disclaimer Privacy Copyright Contact Us Query Form Home

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