Skip to main content
P
Paulbreininger
Participant
December 17, 2009
Question

How do I create a One to many relationship page in Dreamweaver?

  • December 17, 2009
  • 2 replies
  • 505 views

How do I create a page in dreamweaver that comes up after the user logs in from the log in page that will allow the user to:

Add, change and delete in 2 tables that are in my MYSQL database that is a one to many relationship


One thing that is confusing is how the foreign key that links to the one side of the relationship is created in the many side without the user inputting the foreign key each time adding information to the many side table.


I am creating this in Dreamweaver using a MYSQL database and PHP.

This topic has been closed for replies.

2 replies

J Cellini
J Cellini
Inspiring
December 17, 2009

In order to use SQL, you should know something about database design. Do a Google search for something like "how to design a database."

B
bregent
Participating Frequently
December 17, 2009

I would use a stored procedure to handle this. AFAIK, Dreamweaver behaviors do not handle multiple table updates/inserts.

P
PaulbreiningerAuthor
Participant
December 18, 2009

Can you tell what the stored procedures would be?

Would the following be a part of it:

Outer join

set

David_Powers
David_Powers
Inspiring
December 18, 2009

I have moved this thread to the Dreamweaver Application Development forum, which is the appropriate place for discussion of database and other server-side issues.

Paulbreininger wrote:

Can you tell what the stored procedures would be?

Before asking that question, you need to establish whether your version of MySQL supports stored procedures. They were added to MySQL only in version 5.0. Many hosting companies are still running older versions.

The other point you need to take on board is that Dreamweaver's PHP server behaviors don't support stored procedures. Whichever route you finally take, you will need to code everything yourself.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices