Jump to content


Photo

MYSQL Categories with corresponding food items


  • Please log in to reply
1 reply to this topic

#1 nazca

nazca
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 15 June 2006 - 06:49 PM

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....

#2 Ninjakreborn

Ninjakreborn
  • Members
  • PipPipPip
  • Information Technology Specialist
  • 3,922 posts
  • Age:33

Posted 15 June 2006 - 08:08 PM

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.

------

Business Website: http://www.infotechnologist.biz

Personal Website: http://www.joyelpuryear.com

Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users