nazca Posted June 15, 2006 Share Posted June 15, 2006 My first posting, YEAH!! How would you create the following from MYSQL:Appetizers Wings Potato Skins SoupSalads Ceasar Chef Chicken CeasarMain 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 cannotmake separate query calls.... I know I have to use while loops, but I am having problemsrepeating 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 oneHope you can help.... Quote Link to comment https://forums.phpfreaks.com/topic/12094-mysql-categories-with-corresponding-food-items/ Share on other sites More sharing options...
Ninjakreborn Posted June 15, 2006 Share Posted June 15, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/12094-mysql-categories-with-corresponding-food-items/#findComment-46063 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.