Another way is to set a testing variable and then print an <hr> if it
changes
(this off the top of my head, probably bugs in it but you get the idea)

while $myrow=mysql_fetch_row($result) {
if $myrow["dishtype"]<>$test {
    echo "<hr>";
//here you would print the rest of the info about the dish from the row
    }
$test=$myrow["dishtype"];
}

Keiran Wynyard wrote:

> 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

Reply via email to