hello everybody
i want to make yellow pages for my site...
what is better ?
solution one) i have two table main category and sub category... i have sub category which goes to more then one main category eg.Auto Insurance (sub cat) will go to Insurance and Automobile (main cat)
is it advisable to use subcat table to store multiple values is a field like Auto isurance , in , Insurance, Automobile
or create another table to store / maintain relation ships
thanks...
Making Directory Like Yellow Pages (HELP)
Moderator: General Moderators
-
moizshabbir
- Forum Newbie
- Posts: 2
- Joined: Fri Jul 18, 2008 2:34 am
- Ollie Saunders
- DevNet Master
- Posts: 3179
- Joined: Tue May 24, 2005 6:01 pm
- Location: UK
Re: Making Directory Like Yellow Pages (HELP)
I would start by Googling for articles on categories in databases there are a number of good ones.
-
moizshabbir
- Forum Newbie
- Posts: 2
- Joined: Fri Jul 18, 2008 2:34 am
Re: Making Directory Like Yellow Pages (HELP)
i have googled it .... the thing is i dont find my answer on this issue... like what i asked... if u can suggest the solution it will help///