PHP and MySQL help please?!

[hlstriker]

Hey I have a quick question. I am trying to make a page that users can sign up, then later on add things of what they have to sell. Would I need to give each user their own table for this, or could I somehow do it with 1 table?

For example: User "Ned" signs up, then he later on adds things to sell (which would go into a field).

There will be multiple users, that's why I wondered if I had to make more then 1 table, since I don't know if there could be multiple item's in 1 field?

[AndyB]

Two tables - one for users, the other for items for sale

table 1: user_id, username, password, email, whatever else - one record per user
table 2: id, user_id, item_for_sale,price, whatever else - one record per item for sale

[hlstriker]

Thanks alot AndyB!  :D

[extrovertive]

[quote author=AndyB link=topic=102022.msg404360#msg404360 date=1153972828]
Two tables - one for users, the other for items for sale

table 1: user_id, username, password, email, whatever else - one record per user
table 2: id, user_id, item_for_sale,price, whatever else - one record per item for sale
[/quote]


Is id in table 2 a primary key? If so, what if a user_id has many things to sell? Shouldn't there be just a table that list just the unique item for sell?

[sonal4php]

user_id is primary key for 1st table
and id for second table
if a user inputs multiple items , those will be saved to second table against same user_id
so while fetching,
fetch all rows and create table or something like that.....

[extrovertive]

Ah I see now.