One small question!

influx

People can come to my site, sign up, and their information is stored in a USERS table. They have a unique (auto-increment, primary key) id, username, first name, last name, etc. Now, I have a wishlist for them to fill out when logged in, which uses the table WISHES.

In my WISHES table, I want to store the user's unique id that is stored in the USERS table. What would I need to do to call the unique id from the USERS table, and put it in the WISHES table?

Thanks a lot in advance guys!

P.S: what is a unique key?

leatherback

Hey Influx,

Still working on your wishes! ;-)

-- Could you please not cross-post this message to multiple boards? --

As for getting the ID (A unique ID is nothing more then a unique code, which coul dbe just and automatically incrementing integer colum for a specific feature, such as a user: Each user has their own unique number, used for identification).

I suppose you have your users log in to the site with a password/username?

If you then say

$queryres = mysql_query(select id from users where username='$username' and pass='$pass') or die(mysql_error());
while($row = mysql_fetch_array($queryres))
{
$id = $row[id];
}

you get the id from the users table, which you can then use as a user identifier in your wishes table.

travelbuff

You need to create a FK field in the wishes table called users_user_id or something similar.

I assume that when the user logs in you drop a cookie or start a session? If so, when you authenticate them, register their user_id as a session variable:

$_SESSION['user_id'] = $row["user_id"];

Then, when you write the insert for the wishes table, just add the user_id:
INSERT INTO wishes (users_user_id , field1, field2) VALUES ('$_SESSION['user_id']', $field1, $field2 )

I know that seems a little vague, but hopefully it points you in the right direction.

influx

Darn leatherback! Thanks a lot guys, I'll try exactly what you said when I get home. I am not using cookies by the way...I'm using sessions.