Re: Grouped sql output

Hi, I've done this before in coldfusion. It's the one thing I'm note sure on how to do the same(ish) in PHP - my language of choice. If we have the record set the CF code would look like <ul> <cfoutput query="customers> group="zip"> <!--- loop through record set ---> <li>#zip# <ol> <cfoutput> <!--- inner loop on group by zip ---> <li>#customer# </cfoutput> </ol> </cfoutput> </ul> So I'm think also to use 2 loops for the same purpose in PHP. Can I do this from the record set like above or do I need to build array's I wonder ? Cheers Rudi. > Thanks Sven, > > I've already got the sql OK. > I have the records set but I want to print it "report like" > So It's needs some thing like a loop with an inner loop Like > > <ol> > > <li>zip > <ul> > <li>customer > <li>customer > </ul> > <li>zip > <ul> > <li>customer > <li>customer > </ul> > > </ol> > > Hope this makes sense. > I'll elaborate more if you think I should. > Cheers > Rudi. > > > Hi friends, > > > > > I've been struggling for a while now so I thought I'd ask. > > What's the easiest way to for to print group sql output. For > > example I need to output customers grouped by zip. Like: zip > > customer a customer b zip customer d customer e zip customer > > c custoemr f customer g > > > > Do I need to build array's and loop through them or > > can I print straight from a record set ( using Postgresql > > or Mysql ) Thanks heaps ! Regards Rudi. > > > > ============================================================= > > Get your personalised email and homepage at www.easymail.info > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > ============================================================= ============================================================= Get your personalised email and homepage at www.easymail.info