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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
