FW: PHP Question on MySQL grouping
| From: | Keiran Wynyard | Date: | Fri, 01 Mar 2002 14:50:37 +0000 |
| Subject: | FW: PHP Question on MySQL grouping | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-17389@lists.php.net to get a copy of this message | ||
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