///////// Getting the data from sql table for first list box//////////@$quer=mssql_query("Select fnname, fnfrom TESTING.DBO.feeds "); ///////////// End of query for first list box////////////

/////// for second drop down list we will check if fnname //is selected else we will display all the itemcodes///// if(isset($fn) and strlen($fn) > 0){@$quer2=mssql_query("select itemcode from TESTING.DBO.feed_pricelist where fn = '$fn'"); }else{ $quer2=mssql_query("select itemcode from TESTING.DBO.feed_pricelist where fn = '$fn'"); } ////////// end of query for second itemcode drop down list box

///// third drop down box query again check if the //category has been selected else we will display all the subcategory