Hi all,
I have to design a left navigation
jsp page for my website. this page will be included in all rest of the jsp pages.
I am storing the links of other jsp's in database my database table for storing link is somewhat like this :
Link_Id varchar(36)
LinkTxt varchar(50)
ParentItem varchar(6)
Level int(1)
isSubLevel tinyint(1)
PageLink varchar(150)
I am not getting any idea to write a query to retrieve particular link and its submenu items.
I am not getting any idea that what data type i should use, to store the links and its submenu links and send the data to jsp page.
please provide me with some idea or provide some link to solve this problem.
[ October 05, 2005: Message edited by: Bear Bibeault ]