Making Directory Like Yellow Pages (HELP)

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
moizshabbir
Forum Newbie
Posts: 2
Joined: Fri Jul 18, 2008 2:34 am

Making Directory Like Yellow Pages (HELP)

Post 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...
User avatar
Ollie Saunders
DevNet Master
Posts: 3179
Joined: Tue May 24, 2005 6:01 pm
Location: UK

Re: Making Directory Like Yellow Pages (HELP)

Post by Ollie Saunders »

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)

Post 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///
Post Reply