Page 1 of 1

Making Directory Like Yellow Pages (HELP)

Posted: Fri Jul 18, 2008 2:53 am
by moizshabbir
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...

Re: Making Directory Like Yellow Pages (HELP)

Posted: Fri Jul 18, 2008 11:34 am
by Ollie Saunders
I would start by Googling for articles on categories in databases there are a number of good ones.

Re: Making Directory Like Yellow Pages (HELP)

Posted: Sat Jul 19, 2008 5:09 am
by moizshabbir
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///