Need DB structure

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
akhilesh1010
Forum Newbie
Posts: 15
Joined: Thu Aug 22, 2013 1:56 am

Need DB structure

Post by akhilesh1010 »

I have a directory website I am using category and sub categories based business I want to provide facility to our users so that they can add there business in multiple categories. can any one provide me Best Database Structure to manage this option. I am using MySql with PHP. My site is http://www.innobit.co.in/
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: Need DB structure

Post by requinix »

Businesses in one table, list of categories in another, and a third table relating the two (one column for the business ID, one for the category ID).
Post Reply