I need to loop through a grouped recordset adding a <hr> at the 
end of each group, how can groups in recordsets be identified in
PHP for specific formatting.
 SELECT name AS name, dishtype AS dishtype, price AS price
 FROM dishes
 WHERE used = 1
 GROUP BY dishtype, name
 ORDER BY dishtype, price DESC
The use is in the display of a menu for a restaurant, where there 
is a table containing all the dishes on the menu in any given 
instance, but they musst be displayed in a specific order, 
grouped by type. In other words, all Starters come first, 
followed by Main courses, followed by Desserts. Between each type 
there needs to be a seperator, the horizontal line.
 Thanks for you help

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to