Making Directory Like Yellow Pages (HELP)
Posted: Fri Jul 18, 2008 2:53 am
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...
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...