Restaurant menu
| From: | Craig Hoffman | 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