yet again, hi
maybe what i said earlier won't work, i think subquerys aren't supported in mysql 🙁 , but i'll post this anyhow as it is working (this time i've tested it😉 )
first: you said in your members table you had a field called service. That doesn't work, so you should get rid of it. As i said above, what you need is a second table to deal with the 'multiple' relationships. let's call it m_s (feeling sleepy now, waiting for someone to answer my post before going to bed, but you can think of a better name). in it, you'll have an unique id, a member_id and a service_id. So, if it has:
ID | MEMBER_ID | SERVICE_ID
1 | 17 | 90
1 | 17 | 95
it means: the member whose id is 17 has services 90 AND 95.
Ok, how to access all services from a single member in a single query? As I said, subquerys are out (I think), so we'll use something else.
here:
select service.* from service, m_s where m_s.member_id=YOUR MEMBER ID HERE and service.service_id=m_s.service_id
what the above will do is select everything in the service table where the id is equal to the ids in the m_s table where the member_id is what you specified it to be.
again, throw this in a mysql_query in php and you should get what you asked for.
think that's about it.🆒
Caluã
