HI All,
I have three tables tbl_category, tbl_subcategory, tbl_product . where categoryid is foreign key in subcategory table and subcategoryid is foreign key in prduct table. I want to show category and subcategory on home page menubar. I just reach upto display category on menubar but not able to get subcategory on mouseover of particular menu.
So I have a servlet to retrive data and jsp to display it.and jsp code is as below which can show only category.
<ul>
<% Iterator itr;%>
<% List data=(List)request.getAttribute("data");
for(itr=data.iterator(); itr.hasNext(); ){
%>
<li><a href=""><%=itr.next()%></a></li>
<%}%>
</ul>
can you please help me to show subcategory on mouseover