Re: Grouped sql output

Hi Rudi, > 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 ? No need for arrays - the resultset from the RDBMS effectively is one - SQL-talk says it's a table (please show us your SQL query if you have any doubt about this). Make sure the SQL resultset is sorted/grouped correctly! You're approach looks right to me - just more CF than PHP-like. How's this? query RDBMS check result ok/have at least one row extract first row initiate presentation WHILE not EoD note zip code ECHO zip heading WHILE this row's zip == noted zip AND not EoD ECHO customer data end while zip extract next row from resultset end while data terminate presentation OK? Regards, =dn