# Newbie q about saving data to mysql

**URL:** <https://www.ruby-forum.com/t/newbie-q-about-saving-data-to-mysql/58457>\
**Category:** Rails\
**Created:** [April 21, 2006, 8:55pm UTC](https://www.ruby-forum.com/t/newbie-q-about-saving-data-to-mysql/58457 "2006-04-21T20:55:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![vince](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b5e925/32.png) [@vince](https://www.ruby-forum.com/u/vince)\
**Post date:** [April 21, 2006, 8:55pm UTC](https://www.ruby-forum.com/t/newbie-q-about-saving-data-to-mysql/58457/1 "2006-04-21T20:55:26Z")

</div>

I have a two tables in my DB: users and products and I tried to set up a  
foreign key relationship between the id field in user and a user\_id  
field in product.

Despite redoing my scaffold the user\_id does not show up when I go to  
create a new user. Is that normal?

More importantly, how can I save the user id of the logged in user to  
the user\_id field in my product table? Currently my create code looks  
like this:

def create  
warn @user.id  
@product = Product.new(params[:product])  
@product.id = @user.id  
if @product.save  
flash[:notice] = ‘Product was successfully created.’  
redirect\_to :action =\> ‘list’  
else  
render :action =\> ‘new’  
end  
end

PS: @warn.id is shows the correct ID of the logged in user so at least  
that works…

---

<div class="post-metadata">

**Author:** ![vince](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b5e925/32.png) [@vince](https://www.ruby-forum.com/u/vince)\
**Post date:** [April 21, 2006, 10:23pm UTC](https://www.ruby-forum.com/t/newbie-q-about-saving-data-to-mysql/58457/2 "2006-04-21T22:23:39Z")

</div>

Ok, solved it.

Dumb mistake. Needed to add this:

```
 @product.user_id = @user.id
```

---

<div class="post-metadata">

**Author:** ![vince](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/v/b5e925/32.png) [@vince](https://www.ruby-forum.com/u/vince)\
**Post date:** [April 22, 2006, 2:58am UTC](https://www.ruby-forum.com/t/newbie-q-about-saving-data-to-mysql/58457/3 "2006-04-22T02:58:42Z")

</div>

You should also be able to say:

@product.user = @user

Which is more idiomatic rails.

–  
– Tom M.