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 T. Beresford, Owner
Digital Studio Design
Edmond, OK

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

Reply via email to