parsec
Posts: 9
|
| Posted: 03/12/2006, 3:35 AM |
|
Hi
I Try to understand the example Yellow Pages. In the table yp_categories I understand the category_id, category_name, been there
but why you have put the category_id_parent in the same table would it been better to have the parent deceptions and ID in another table and pull data from there.
I ask this since I would like to use the builder to produce the same effect betweenness Department and Category tables that I have
My tables look like this
Department (table name)
ID
Name
Category (table name)
ID
DepartmentID
Name
Can some please recommend how to do this
Thank you
|
 |
 |
idh63
Posts: 76
|
| Posted: 05/05/2006, 7:10 AM |
|
Hi parsec,
I just found your post looking for the answer to the same question.
You may have found the answer by now.
I expect that using one table would be less overhead on the server than 2 tables.
I was considering using three tables to create a many-to-many relationship and only have any category or sub-category named once instead of Apparel/Accessories and Automotive/Accessories. Accessories would have to be repeated in two records if one table was used.
I'd be interested to hear if you found a solution.
|
|
|
|
|
