MySQL Forums
Forum List  »  PHP

Re: One to Many Relationships in MySQL with PHP
Posted by: Zaeem Ahmed
Date: June 20, 2007 12:01PM

i am designing a website for transport system
one user can have many requests for Trip
i have two tables

Members(memberID not null primary key,memberName varchar(20),meberAdd varchar(30))

tripRequest(tripID not null primary key,destination varchar(25),city varchar(20))

Relationship is from "Members" to "tripRequest" (1 to many relationship)

i know "memberID"(attribute) from "Members" should come as Foreign key in "tripRequest" but don't know how to make this relationship

Options: ReplyQuote


Subject
Written By
Posted
Re: One to Many Relationships in MySQL with PHP
June 20, 2007 12:01PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.