lauragib

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...