| Index
» Projects
» phpMyEdit
» Forum
» table relations / associations |
 |
tomabroad
Joined: 26 Feb 2010
Posts: 2
Posted: 2010-02-26 19:46
Back to top
Reply with quote
|
hi, i have two tables, both are related to each other with a N<>N relation, meaning a Many to Many association (TableA and Table B).
Now, i created the TableC, which is supposed to hold the two keys (tableA_id & tableB_id), but how do i create / get some dropdowns / selectoptions working? do i need to hack that manually?
thx
|
doug
Joined: 10 Feb 2003
Posts: 1013
Location: Denver, Colorado (USA)
Posted: 2010-02-27 03:32
Back to top
Reply with quote
|
phpMyEdit does not work with tables using two columns to create the unique key.
|
tomabroad
Joined: 26 Feb 2010
Posts: 2
Posted: 2010-03-01 15:07
Back to top
Reply with quote
|
ok, so whats the best approach here? i could drop the auto_id in the join table and just store both of the foreign_keys. but how would i reflect that and include as selection-options in phpmyedit?
thx
|
paddywwoof
Joined: 25 Feb 2010
Posts: 7
Posted: 2010-03-02 09:37
Back to top
Reply with quote
|
I can't tell exactly how you inted to use your tables. With phpMyEdit you will have to insert new records in tblA, tblB and tbleC on their own (i.e. I don't know how you can use it to add linked records to more than one table at the same time).
If the records can be inserted into tblA and B independently then joined afterwards by inserting records in to tblC you can do this with the standard dropdown.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
