RE: [PHP-DB] Grouped sql output

Hi, Thanks for the input, I'll stop messing around and post some code Be warned this code is untested :-) It's kinda like thinking out loud. I think this should produce a nested list output from a query. Given this query : SELECT count(zip) AS zipcount,zip,cust_last_name FROM customers GROUP BY zip ORDER BY zip,cust_last_name; My php code might look like : ( for Postgresql ) $thiszip = pg_result($res,0,0); // the first zip code in the record set echo "<ul>"; // open main list for ( $i=0; $i<=pg_numrows($res); ++$i ) // begin loop over record set { if ( pg_result($res,$i,0) != $thiszip ) // if this zip is the same as the last { if ( $thiszip != "no_zip_yet" ) // if this is true we have an open ol list { echo "</ol>";} echo "<li>".pg_result($res,$i,0); // output zip code echo "<ol>"; // open inner list echo "<li>".pg_result($res,$i,1); // output customer data $thiszip = pg_result($res,$i,0); // track current zip } else // zip is same as last one { echo "<li>".pg_result($res,$i,1); // output customer data } } // finish loop. echo "</ul>"; // close main list. What do you think ? I'll test it tomorrow at work. I'll let you know how she goes. Thanks for your time, suggestions and attention. Much appreciated. Regards Rudi. ============================================================= Get your personalised email and homepage at www.easymail.info