Welcome Guest, Not a member yet? Register   Sign In
Need help with a bridge table.
#1

[eluser]acreek[/eluser]
Hi all,

I am trying to create a database that will tell me what users have access to specific services. I set my tables up like so

customers:
id name
1 Brian
2 Nate

services:
id name
1 Phone
2 Internet

services_bundles:
customer_id service_id
1 1
1 2
2 1

So right now I have a query set up that will pull a 'name' LIKE. What I am trying to accomplish is when you search a name it will pull the service_bundles information and display what services are available to that customer.

I'm using code igniter for the first time, and having a heck of a time with active record. Could someone help me out please?

Thanks


Messages In This Thread
Need help with a bridge table. - by El Forum - 08-04-2009, 07:54 AM
Need help with a bridge table. - by El Forum - 08-04-2009, 08:43 AM
Need help with a bridge table. - by El Forum - 08-04-2009, 08:53 AM
Need help with a bridge table. - by El Forum - 08-05-2009, 08:17 AM
Need help with a bridge table. - by El Forum - 08-05-2009, 08:23 AM
Need help with a bridge table. - by El Forum - 08-05-2009, 09:18 AM
Need help with a bridge table. - by El Forum - 08-05-2009, 09:45 AM
Need help with a bridge table. - by El Forum - 08-07-2009, 09:33 AM



Theme © iAndrew 2016 - Forum software by © MyBB