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.

tcp

I use a unique id tag for each user.

And then to insert;

$sql = "INSERT INTO screenname (userid, title, date, comments) 
               VALUES ("$userid','$title','$date','$comments')";

Alidad

thanks so much for you response. this a bit small confusined myself, are you saying that i should add another new column in screenname table (userid) !

If so, then that mean the value of userid is come from screenname table name (userid) but not from php forms is that correct!

Kudose

I'm not sure that I understand your last post, but you would need a column in both tables that reference each other and share the same unique value. This is used to link the information together with a unique value, such as a userid column with an auto incrementing integer field.

http://databases.about.com/od/specificproducts/Database_Design.htm

tcp

Yes, an autoincrement field is what I had in mind. My table would look something like...

Registered table:

userid(autoincrement)
First name
Last name
User name
Password

Screen table:

screenid(autoincrement, a "userid" for the screentable)
userid(to identify registered member)
Title
Category
Date
Comments

userid is automatically assigned when the user is created in "registered" table, likewise for screenid.

Alidad

So in php, what do i need to write in php statment to see result from screenname database!

Do i need to write relationship database statments or that tables will take care of everything!

JVassie

Depends what you are trying to do.

For example if you wanted to view all results from the screen table for a specific userid you could do it like this:

"SELECT * FROM Screen WHERE userid = 'x'"

If you wanted to get information from both tables, like this:

"SELECT registered.First name, registered.Last name, registered.User name, Screen.Title FROM registered, Screen WHERE registered.userid = Screen.userid"

Im guessing you know how to form MySQL queries? 🙂