I am making a website of a resturant.
in database I have created two tables
1-food(id,food_name,cat_id(F.K),)
2-category(cat_id,cat_name)
I want to display the category in navigation bar and on clicking the category it has to show the respected food that comes under the category.
example I have the following entries in my table
food_name=Zinger Burger,Chicken Burger,Sea Food
cat_name=FastFood,Fish
I have to show the category on menu bar and on clicking the fastfood it shows the zinger and chicken burger.