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