Restaurant menu

From: Date: Sat, 22 Jul 2006 02:40:52 +0000
Subject: Restaurant menu
Groups: php.db 
Request: Send a blank email to php-db+get-42240@lists.php.net to get a copy of this message
Hey there, I'm working on a menu system for a catering company. I'm having a difficult time sorting and grouping items together. For example, there may be three or four appetizers that should be group together. But I only want to display the category (appetizers) once and then the corresponding items (A, B, C,...). I'm drawing a blank on how to go about this. My DB consists of 4 tables (categories, items, item_attributes, menu) but the menu table is most the important. The menu schema is below. menu_id menu_name menu_category => pulls from the categories table (appetizers, starters, etc...) menu_item => pulls from the items table (Cherry Pie) menu_item_atttribute => pulls from the attribute table (Hot, cold, etc) Example: Menu Name: xxxxx Appetizers A B C D Desserts A B I'm open to all suggestions / ideas. Thanks - Craig

« previous php.db (#42240) next »