Jump to content

Archived

This topic is now archived and is closed to further replies.

lauragib

Mysql Newbie needs help!

Recommended Posts

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.