RE: [PHP-DB] Restaurant menu

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@eclimb.net> To: PHP List <php-db@lists.php.net> Subject: [PHP-DB] 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