Hi guys,

Hoping I can find some help.

I just installed Xampp and I'm trying to use PhpMyAdmin to create a database to do the following:
------------------------------------------------------------------------------
A diet plan that will pull from a database of meals (Breakfast, Lunch, Dinner, Snacks) and create a meal plan for 7 days like this

Monday Tuesday Wednesday Thursday, etc.
-Breakfast -Breakfast
-Lunch -Lunch
-Snack 1 -Snack 1
-Dinner -Dinner
-Snack 2 -Snack 2

(Snack 1 and 2 will pull from the same database)

It will also produce a grocery list for the week
-------------------------------------------------------------------------------

So basically the Php/MySql should produce 3 outputs (to MS Word):
1.) A short list of the meals for 7 days
2.) A long list of the meals for 7 days
(includes ingredients, and cooking directions)
3.) A grocery list

-------------------------------------------------------------------------------

So I need some help on the database structure does this seem about right??

Database: Diet

Table 1: Breakfast
Brkfast_Key Auto_Increment
Brkfast_Name
Ingredient
Ingredient_Amt
Ingredient_Amt_label
Brkfast_Description

Table 2: Lunch
Lunch_Key Auto_Increment
Lunch_Name
Ingredient
Ingredient_Amt
Ingredient_Amt_label
Lunch_Description


Table 3: Dinner
Dinner_Key Auto_Increment
Dinner_Name
Ingredient
Ingredient_Amt
Ingredient_Amt_label
Dinner_Description

Table 4: Snack
Snack_Key Auto_Increment
Snack_Name
Ingredient
Ingredient_Amt
Ingredient_Amt_label
Snack_Description

Table 5: Ingredients
Ingredient

Table 6: WeekMeals
Day_of_Week
Brkfast_Name
Brkfast_Description
Lunch_Name
Lunch_Description
Dinner_Name
Dinner_Description
Snack_Name
Snack_Description
Ingredient
Ingredient_Amt
Ingredient_Amt_label

Table 7: GroceryList
Ingredient
Ingredient_Amt
Ingredient_Amt_label


I'm brand new to MySql, PhpMyAdmin, and Php. I've only taken a short computer system class in college that cover some information on Microsoft Access so any help would be greatly appreciated.

Thanks!

(I feel I should say I have posted this same post in other MySQL type forums, I know I shouldn't but just wanted sure I get a response from someone)