I have a doubt about relationship and how to show it.
I have a channel which can have many channels, which can have more channels, which can have more channels..........
How can I relate them?
I thought that each channel can have a field that tells which channel it's related to, like:
id name related_channel
2 example1 null
3 example2 2
4 example3 2
5 example4 4
what do you think about it?
After relating them, how can show all the channels that are under a channel?
Thanks in advance!
I am a big fan of the self-joins, especially with stored procs to do near recursive (but not) operations on them. I wrote up an example in this link. Let any of us know if you need any help like that. Good luck.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments