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