php mysql-connect 2 tablesphp mysql
Posted 02 February 2013 - 03:40 PM
item has => item_id(unique_1), item_describe,item_cost,item_unit_price
user => user_name, psws, last_name
so whenever user logins inside and adds a item, i want to connect that adding of items with the user.
may b looks simple, but i want to do it without adding any extra field in tables.. is that possible.. Or else if i make item_id as primary, then how should i proceed?
And if item_id is not unique, if 2 users have same items addition with same id,cost_price, how could that be achieved?? thnks in advance...
Posted 02 February 2013 - 04:49 PM
CREATE TABLE useritem ( user_id INT, item_id INT, PRIMARY KEY(user_id, item_id) )
if an item can be owned by one or more users and users can have one or more items then you use a link table to reconcile the many to many relationship
Edited by Barand, 02 February 2013 - 04:51 PM.
- PHP_CHILD likes this
If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users