PHP_CHILD Posted February 2, 2013 Share Posted February 2, 2013 i have 2 tables, items and users. 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... Link to comment https://forums.phpfreaks.com/topic/273956-php-mysql-connect-2-tables/ Share on other sites More sharing options...
Barand Posted February 2, 2013 Share Posted February 2, 2013 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 Link to comment https://forums.phpfreaks.com/topic/273956-php-mysql-connect-2-tables/#findComment-1409741 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.