MySQL Forums
Forum List  »  PHP

One to Many Relationships in MySQL with PHP
Posted by: Andrew Alsoszatai-Petheo
Date: June 06, 2006 05:25PM

I am having problems creating a one-to-many relationship using php and dreamweaver. I currently use SQLYog for my database and easyPHP 1.8 for the servers and Dreamweaver MX 2004 for the Web editing. I have a database of books which I have placed into a php website. It's actually really cool! It functions much like amazon.com's book database. the part I am missing is authors. In amazon, when you look up a book, it has more that has more than one author, all of the authors names show up. I can only get one to show or get that same book to show several times (as many as there are authors). One book can be written by many authors. I have set up the database in MS Access and have all the tables normalized and the database functions properly. so I exported the database into SQLYog and am using this instead of access. When I set up my database, I can not put in any authors (not because I don't have the knowledge) because I can not set the relationship with the correct tables. Is there a php trick to get this to work or is there a better (free) alternative to SQLYog that can correct this problem.
Here are the tables

Book (Table)
---------------
BookNum
Title
Subtitle
Edition
Publisher
Pages
...

Author (Table)
---------------
AuthorNum
AuthorFirst
AuthorLast
AuthorMI

Wrote (Table)
----------------
BookNum
AuthorNum

There are other tables but they are not important to this question

In Access the relationship is:

Book Wrote Author
------ ------- --------
BookNum -1---M- BookNum AuthorFirst
Title AuthorNum -M---1- AuthorNum

Now if I add a book to the Dreamweaver site, I can not add more than one author to a book because the one book repeats itself by however many authors I have for that book. I know for a fact this is either the fact that one to many (1-M) relationships dont exist in SQLYog or there is a php code I am missing.

Please do not hesitate to ask me for any code, more of the database, SQL recordsets in dreamweaver, etc. I am abliged to help you if you help me or at least point me in the correct direction.

http://alsoszaa.awardspace.com/bookdb/catalog.php

you need to use the following credentials:
username: test
password: password

The site is not complete so please don't mind the buttons that don't work.

when you click on the book title it takes you to a detailed page. On this page is where I want the authors to appear. my database file is called "alsoszaa_books"

If possible, would you know how to change checkmarks in a database to yes/no because the CD Included part shows up as 1 or 0

Options: ReplyQuote


Subject
Written By
Posted
One to Many Relationships in MySQL with PHP
June 06, 2006 05:25PM


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.