multiple items for one service problem
Posted: Mon Feb 07, 2011 1:43 pm
how can i make a mysql database that supports a
1. title
2. then a list of services the user inputs that is then displayed
the problem im running into is that how can i sync the title with the possibly infinite number of services.
i want each service to be individual
would i have to create a seperate table for the services?
maybe i could create a table with the auto increment ID then the title
then another table that has the ID of the corresponding first table with the quotes
so it would look like this
service title table:
(auto increment id,
service title)
service list table:
(id from first table,
services)
so then how would i get a query that would pull these tables together?
1. title
2. then a list of services the user inputs that is then displayed
the problem im running into is that how can i sync the title with the possibly infinite number of services.
i want each service to be individual
would i have to create a seperate table for the services?
maybe i could create a table with the auto increment ID then the title
then another table that has the ID of the corresponding first table with the quotes
so it would look like this
service title table:
(auto increment id,
service title)
service list table:
(id from first table,
services)
so then how would i get a query that would pull these tables together?