Jump to content

Archived

This topic is now archived and is closed to further replies.

nazca

MYSQL Categories with corresponding food items

Recommended Posts

My first posting, YEAH!!

How would you create the following from MYSQL:

Appetizers
Wings
Potato Skins
Soup
Salads
Ceasar
Chef
Chicken Ceasar
Main Meals
Steak
Prime Rib

.... Until all the categories and food items are complete and in their right category...
I want all appetizer foods under the appetizer heading and so forth.
I do not know how many categories there are with different menus so I cannot
make separate query calls.... I know I have to use while loops, but I am having problems
repeating the category name than food item than category name than food item. It does not
do it once for each category.... I figure COUNT AS will come into play... but I am lost on this one

Hope you can help....

Share this post


Link to post
Share on other sites
I am a little confused on what you are trying to do, can you re-explain, and post the current code you have been playing with for this, if any.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.