lauragib Posted May 6, 2003 Share Posted May 6, 2003 Hi all, this is my first mysql database , I have got all my tables in the database, I need to know how to make the tables interact with each other. Here is what I have MerchantID Merchant MerchantLink CategoryID Category DealID Deal DealLink DealstartID Dealstart DealExpireID Deal Expire My website has several different pages (Apparel,Electronics,etc) So I need to make this database display data according to the page (e.g.Apparel). There will be several merchants to one category There will be several Categories to one merchant There will be several Deals to one merchant There will be several Deals to one Start Date There will be several Deals to one Expire Date My question is how do I do this?? Please the simplest instruction possible....LOL I do good with visual examples.... Thanks in advance for your time................Now to go post a php question... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.