need help please...

[Alidad]

Perhaps someone can help me with an example I've come up with to help me to better understand how to build a relationship in Mysql.

 

I have database name “members” and two table name “registered” and “Screen”

 

Registered table:

 

First name

Last name

User name

Password

 

Screen table:

 

Title

Category

Date

Comments

 

What they do is that when member log in from registered table, then input information then send data to the Screen table.

 

Now I have two questions:

 

1) How would or SHOULD I go about creating the database relationship to show that the screen table is come from right user name!

 

2)  How do I create insert statement into the Screen table that come from right user name!

 

Please help thanks.

 

AM

 

[Maq]

Let's look at question #1:

 

1)  How would or SHOULD I go about creating the database relationship to show that the screen table is come from right user name!

 

You need to have a unique ID.  So in your users table have a field called, "id", and have it auto-increment.  You have to have a field in the SCREEN table called, "user_id" so it knows which id goes to each record.

[Stefan]

I found that there is nothing like a good e.g

 

So maybe this can help http://www.tizag.com/mysqlTutorial/mysqljoins.php

[fenway]

Don't double-post next time.