Hello all, Am struck in the middle of a project. i use Mysql, tomcat3.2.1 on win 98. Actually the requirement is that, data from a field in a mysql table needs to be read and displayed within a combo box. no idea as to what should be done..pls help. the combo that displays the field from a table will be used to select options in a html file and the option thus selected got to be stored back into another table eg: Product category - say..Grocery, Cosmetics Product name - Spices, Perfume... So if a user is going to add he/she should select from the predefined category Grocery, cosmetics etc. Then the user will enter the specific prod name into a text field...
Joined: Apr 11, 2001
hello gk, as far as i have understood,i think u want to display contents in a combo box dynamically.isnt it? in the loop where u check whether the resultset is null ,get the data from the table and put it in the option tag.i.e before the loop give the select open tag.in the loop give one option tag and get the string from resultset,after the loop end the select tag. try it out and reply. good luck