Hey Craig,
Place all items whatever way you want in a table. Its while presenting the
menu, you have the query the database like:
$query = "SELECT menu_id, menu_category, menu_item FROM $menu_name ORDER
BY $menu_item_attribute "ASC";
You can choose multiple tables for menu_category, in which case you shall
have to pull out a custom menu by 'joining tables'.
Regrds
KM
On 7/22/06, Craig Hoffman <[EMAIL PROTECTED]> wrote:
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
