mysql - PHP: Return more than one ID of employees/users to a product table -
i have table of products each product has employee/s is/are responsible of. (gets email every update regarding product).
these tables:
table products prod_id | prod_name | prod_ios_id | prod_android_id | **prod_user** table employee **emp_id** | emp_name | emp_email | emp_password | emp_permissions
after submitting function gets more 1 id (or array of ids).
what right way add more 1 id table cell 'prod_user' in case ?
you have add 3rd table.
table products_employee
prod_id, emp_id
the cell prod_user in table products can deleted.
Comments
Post a Comment