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

2002-03-05 Thread Shrock, Court
[mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 3:46 AM > To: [EMAIL PROTECTED] > 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

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

2002-03-05 Thread Keiran Wynyard
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 p

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

2002-03-01 Thread Matthew Crouch
Another way is to set a testing variable and then print an 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 ""; //here you would print the rest of the info about the dish from the