Trade Search

function lst_part_change() { if(document.trd.elements.length>3) document.trd.elements[4]='NULL'; document.trd.submit(document.trd.lst_part) } function lst_trade_change() { document.trd.submit(document.trd.lst_trade) } function txt_part_keup() { for (var i=0; i"; //html_header('Search by Trade Names'); echo ""; echo "

"; echo "
"; @mysql_select_db('frlhtenvis'); $part_qry = "select distinct part from spinfo, envis_botmast where envis_botmast.plant_id = spinfo.plant_id order by part"; $part_rslt = mysql_query($part_qry, $link_id); $trade_qry = "select distinct trd_name from spinfo where part='$part' order by trd_name"; $trade_rslt = mysql_query($trade_qry, $link_id); echo ""; echo ""; echo ""; echo ""; //place ad print ""; //*** echo ""; echo ""; echo ""; echo "

"; echo ""; echo ""; //echo ""; //echo ""; if($part!=NULL) { //echo "

Select a part of the plant used in trade

Select a trade name

";//

"; echo "

"; echo ""; echo "

"; echo ""; } echo "

"; echo "
"; if($trade_name!=NULL) { $trade_qry1 = "select distinct plant_id,trd_name,part from spinfo where trd_name='$trade_name' and part='$part'"; $trade_rslt1 = mysql_query($trade_qry1, $link_id); $loop = mysql_num_rows($trade_rslt1); //echo $loop."
"; //-------- if($loop>1) { $link_query = "select distinct plant_id from spinfo where trd_name='$trade_name' and part='$part' order by plant_id"; $link_query_res = mysql_query($link_query,$link_id); echo "

"; echo ""; echo ""; echo ""; echo "

"; $count=1; while($ahref=mysql_fetch_row($link_query_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 envis_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_pid=mysql_fetch_row($trade_rslt1)) { $plid=$temp_pid[0]; echo "
"; echo ""; echo ""; echo ""; //echo ""; echo ""; //echo ""; echo "

Trade Name: $trnm

$trnm

Part Used : $part

$part

"; //echo "

"; echo "
"; //echo $plid; printTable($plid); } } ?>

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