Hi All,

I'm having a hard time wrapping my head around this. I have a query that returns the following (Sorted by col2):

col1    col2
-------------
house1  Com1
house2  Com1
house3  Com2
house4  Com2
house5  Com3
house6  Com3


I would like to display it as shown below:


Com 1
house1 - Com1
house2 - Com1

Com 2
house3 - Com2
house4 - Com2

Com 3
house5 - Com3
house6 - Com3


I'm having a problem with the header for each 'com'


Thanks for any pointers,
John
--
===========================
John T. Beresford, Owner
Digital Studio Design
Edmond, OK
http://www.digitalstudiodesign.com/
405.760.0794

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to