sheraz Posted May 1, 2010 Share Posted May 1, 2010 Hi, i am new to database designing. i have to create a bridge table in mysql? if you can guide me that how to do a bridge in phpMyAdmin than it will be better for me. Thanks :'( Quote Link to comment https://forums.phpfreaks.com/topic/200363-how-to-create-bridge-table/ Share on other sites More sharing options...
Mchl Posted May 1, 2010 Share Posted May 1, 2010 What do you mean by 'bridge table'? The only thing that comes to my mind is: Quote Link to comment https://forums.phpfreaks.com/topic/200363-how-to-create-bridge-table/#findComment-1051576 Share on other sites More sharing options...
sheraz Posted May 2, 2010 Author Share Posted May 2, 2010 i am talking about many to many relationship dude. i have to create a 3rd table to reference the 2 parent tables, you can say that it will be a foreign key Quote Link to comment https://forums.phpfreaks.com/topic/200363-how-to-create-bridge-table/#findComment-1051763 Share on other sites More sharing options...
Ken2k7 Posted May 2, 2010 Share Posted May 2, 2010 i am talking about many to many relationship dude. i have to create a 3rd table to reference the 2 parent tables, you can say that it will be a foreign key Well, don't use terms that are made up like "bridge table" because obviously it doesn't mean anything to us. I'm sorry we are not psychic. We do try to help, but if we don't understand something, we ask. You probably should be more grateful to people who are spending their free time (without pay) to help you. Don't be mad at us for your bad terminology. Quote Link to comment https://forums.phpfreaks.com/topic/200363-how-to-create-bridge-table/#findComment-1051765 Share on other sites More sharing options...
Mchl Posted May 2, 2010 Share Posted May 2, 2010 Chill... it was a joke. Really.. google for 'bridge table' and you won't find anything about a databases until fifth page. Now. What is your problem with creating such a table? There's nothing more to it, than to creating any other table. table A ------------------- A_id, someData 1 , foo 2, bar ... table B ------------------- B_id, someOtherData 1 , spam 2, eggs ... table A_to_B ------------------- A_id, B_id 1 , 2 2, 1 1, 1 ... Quote Link to comment https://forums.phpfreaks.com/topic/200363-how-to-create-bridge-table/#findComment-1051858 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.