I have a database with several tables that I am trying to pull info from. Here is the layout of the database:
http://www.hogston.com/marketingRequest_layout.jpg
This is used to collect request for info about services offered. The problem is that a user can fill out the form and check multiple services they want info on. The user info is entered in the request table and an entry for each service they want is made in the requestService table along with the matching requestID. but when i pull a list of the entries and join the tables it gives me a row for each service requested.
So if the requestID assigned is 10, and they check 5 different services, I get back 5 rows with the same requestID and all the other info is the same except the service requested is different for each row.
What I want to do is have it list 1 row for the requestID and have all the services listed in the service column, possibly comma seperated or something.
I think it has to be some kind of multidimensional array with a loop in it but I cant find a good example of that anywhere.
Any help someone can give would be much appreciated.
Thanks
Sean
