I want to show menu items from the table

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

element

Loop:2 foreach (product in products)

tbl.addElement(CreateMenu(product)) // this method will create the ment item

" + variety + "

" + prod.ProductName + "

"+ prod.ProductDescription+"

" + prod,ProductPrice + "

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Madhanmohan Devarajan10y ago

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

end Loop2

create blank row

end Loop1

CreateHeader(variety)

hdr = document.createElement("

return hdr

createMenu(prod)

trow= document.createElement("

return trow

element Loop:2 foreach (product in products) tbl.addElement(CreateMenu(product)) // this method will create the ment item
" + variety + "
" + prod.ProductName + "	"+ prod.ProductDescription+"	" + prod,ProductPrice + "