Order the query by the category, when the category changes echo out the new
category like a heading
<?php
...
echo "<table><tr>";
$old_cat = '';
while ($rows = mysql_fetch_array($result))
{
if ($rows['cat'] != $old_cat)
{
echo "<td>" . $rows['cat'] . "</td>";
echo "</tr><tr>";
$old_cat = $rows['cat'];
}
echo "<br />". rows['item'];
}
Bastien
From: Craig Hoffman <choffman@xxxxxxxxxx>
To: PHP List <php-db@xxxxxxxxxxxxx>
Subject: Restaurant menu
Date: Fri, 21 Jul 2006 21:40:52 -0500
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
