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
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