Hi,
I want to create a database like Dmoz(dmoz.org).
I have a problem with creating parent child relation.
I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory of sub-subcategry.
What is the best method to do this relation??
moneypro
0
Newbie Poster
Recommended Answers
Jump to PostI am not sure you need a links table for such a simple structure.
Ensure each row has a unique id, include a column named something like parentId to hold the id of the parent record.
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.