loop table display issue

[samoht]

hello all,

 

I'm a little stumped about how to write the output for what I need.

I have database records that store description information for work done under different categories with the client name and the date.

 

I am trying to write a php foreach loop that will loop through each client and create a table with the category of work in the first column and then the description of the work done in the second column.

 

I have the foreach working fine for looping through by each client. where I am stuck is figuring out how to display all my categories (with their full name and not just the field name) in each table - even if work was not done in that category.

 

 

Hopefully that makes sense.

 

Thanks for any help.