RE: [PHP-DB] Re: FW: PHP Question on MySQL grouping

How about changing: if ($a_row[dishtype] != $loop) to // the $loop variable must be unset before the loop starts // though, so put a unset($loop) right before your while if ($a_row[dishtype] != $loop && isset($loop)) Court > -----Original Message----- > From: Keiran Wynyard [mailto:keiran@wynyard.net] > Sent: Tuesday, March 05, 2002 3:46 AM > To: php-db@lists.php.net > Subject: [PHP-DB] Re: FW: PHP Question on MySQL grouping > > > Thanks to both Aron and Mr Crouch for their help... > > Aron suggested three separate queries, which was a thought I > had originally, > but as I was about to implement that idea, with the extra > code that required > Mr Crouch came along with his 'test' variable idea. The code > I used is at > the end of this post. > > With the information supplied (and a little bug checking of > my own) I am > able to say that I have succeeded in placing an <hr> above > the first entry > of a 'dishtype' group, not exactly what I wanted, but light > years ahead of > where I was. If anyone knows how to place it at the bottom > (or after) the > LAST item of a group I would be most indebted. > > Below is the reworked code that I used incorporating the > ideas that Matthew > sent along, as a closing statement on my question: > ------------------------- > while ($a_row = mysql_fetch_array ($result) ) > { > //strip slashes so input appears correctly > $a_row[name] = stripslashes ($a_row[name]); > $a_row[shorttext] = stripslashes($a_row[shorttext]); > > if ($a_row[dishtype] != $loop) > { > echo "<hr size=\"1\" width=\"30%\" noshade>\n"; > \\the > required <hr> > tag > } > //here I placed more information about the dish > $loop=$a_row[dishtype]; > } > -------------------------- > Thanks a lot guys > > Keiran > ---- > Matthew Crouch <whyyousee@yahoo.com> wrote in message > news:3C801148.64FCC66@yahoo.com... > > 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 >