Hi Professionals,
i`m looking for a solution for a many to many relationship made in Seblod. Would be happy about some ideas.
Example: Relationship between people
There a two tables:
1. Joomla default article table (#__content)
2. Custom table managing the relations of the article table (#__relations)
Data in #__content
article_id, name
1, Max
2, Steve
3, Chris
4, Jenifer
5, Tobias
Data in #__relations
1, 2, 3 (Steve <--> Chris)
2, 3, 5 (Chris <--> Tobias)
3, 1, 5 (Max <--> Tobias)
4, 1, 3 (Max <--> Chris)
5, 5, 4 (Tobias <--> Jenifer)
Note: There a no double relations like "2, 5, 3 (Tobias <--> Chris)" because "2, 3, 5 (Chris <--> Tobias)" already exist.
Goal: Show as result related to the article page "Chris", all related article (Persons).
Result by "Chris" => Steve
- Tobias
- Max
I m happy about your ideas
Best