Fetching id from separate table

[Smudly]

I am attempting to capture the users id from the Users table, and have it copied to the userid row once a user submits a website.

 

Here is the code I am using, and so far it is not working.

 

In my Users table is the user's id number (auto increment) which is called id.

I want that value to be copied over to the websites table in the row called userid.

 

$query = mysql_query("SELECT id FROM users WHERE id='$id'");

$result = mysql_fetch_assoc($query);
$userid = $result['id'];

$query2 = mysql_query("INSERT INTO websites VALUES ('','$userid','$url','$credits','','','','$title')");

 

 

Any suggestions would be awesome.

Thanks

     

 

[ignace]

What is not working? What is the current output? And what is the desired output?