How do I do this with PHP/MYSQL

[thedead]

I have a SQL Database with a table for users with 3 fields right now for ID, USER,PASS.

I want to give each user the ability to add through a form a Fruit, date they ate it, how long it took them, and how much it costed.

This information would need to be stored in the SQL database under the user. I can do that no problem, but if I want to create a second fruit he hate how would I make it store under the same table without overwriting anything?

Does that make sense?

[dagon]

you would have a 2nd table with

id user_id fruit date

then use a join when calling the data, now each user can eat as much fruit as he likes

[thedead]

Thank you!

I just did a search on google and I cant find any good examples. Do you mind writing something simple?

[dagon]

for what inserting data in to the db table?