[snip] Data is as such right now for testing purposes: ID, catName, catLink, catDepartment.
I will have multiple instances of the same text in catDepartment. I realize this is a fopaux. I'm just trying to do a quick fix. none the less I want the data formatted like this: DEPARTMENT NAME 1(catDepartment) DEPARTMENT NAME...n(catDepartment) -------------------------------------------- ------------------------- -------------------- Category1(catName) Category1(catName) Category2(catName) Category2(catName) Category...n(catName) Category...n(catName) [/snip] You need a crosstab query in SQL. Please search google for "crosstab query". -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php