Jump to content


Photo

Mysql Newbie needs help!


  • Please log in to reply
No replies to this topic

#1 lauragib

lauragib
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 06 May 2003 - 10:51 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users