I want to show menu items from the table

Question

Hello  i have two tables 1)tblVariety DID Dishtype AddedDate Dishfilename dishfilepath DT001 Veg 2016-09-30 home-burger.jpg images/ DT002 Non-Veg 2016-09-30 home-menu-bg.jpg images/ DT003 Coffee 2016-09-30 coffee.jpg images/ DT004 Cakes 2016-09-30 chocolate image.jpg images/ 2)tblProducts ProId ProductName ProductDescription ProductPrice VNV MN001 Dosa South indian famous food 60 Veg MN002 Meals Rice and chenna fry and more indian culture 150 Veg MN003 Burger Its chines made culture and fastfoods 80 Veg MN004 Chettinadu chicken Its very tasty and spicy 100 Non-Veg MN005 chicken Loipop this chicken leg piece fry 120 Non-Veg MN006 Grill chicken its very fry in grill machines 350 Non-Veg MN007 choco cofee its hard choco and sweetest without milk 100 Coffee MN008 Mintmojiti mint tast its feel fresh 100 Coffee MN009 Straberry Milkshake Its healthy and sweetest items 150 Coffee MN010 Home Strawberry its a sweetest and tasty 90 Coffee MN011 Chocolate cake its a dark choco and soft emmy 300 Cakes MN012 Mary Berry its formal and crunchi cake 200 Cakes MN013 Buttar confetti its a milk mixed made cake 150 Cakes I want output look like this link wise::: please refer this link http://backupeasy.net/menu.aspx

Madhanmohan Devarajan · Answer

Siva In your case i am not sure about the script or language that you use. I have given you the logic to build the table with all those details you are looking for. Approach: 1. Create main function which calls other two functions (Header and Table) 2. Function to create header dynamically with the contents from tblVariety 3. Function to create table for menu items (from tblProducts) Below seen coding syntax are not correct its just idea and you can convert to any language or script that you use. Main function() tbl = document.createelement( ) Loop:1 foreach (variety in tblVariety) products = select VNV from tblProducts where VNV=variety.DishType tbl.addElement(CreateHeader(variety)) // this method will create element Loop:2 foreach (product in products) tbl.addElement(CreateMenu(product)) // this method will create the ment item end Loop2 create blank row end Loop1 CreateHeader(variety) hdr = document.createElement(  + variety +  ) return hdr createMenu(prod) trow= document.createElement(  + prod.ProductName +  + prod.ProductDescription+  + prodProductPrice +  ) return trow