Click to See Complete Forum and Search --> : Structure Setup Advice


linewire
12-14-2009, 12:40 AM
My site will be holding member information such as username, pass, etc... but in addition to this, each member will have several items that he or she will have added/subtracted from their area (item_number, prices, etc..). How would I go about doing this properly? I was thinking of 2 methods

1) Each member has a 'table' in which the rows are made up of the members item information
2) Each member has a row and the item information is stored in a field and is parsed when the information is output (item_number=009&price=25.25&sales=25,etc..)

any other suggestions? I am leaning towards #1 atm.

ssystems
12-16-2009, 10:59 PM
user table
userId,
username,
password
......

items table
itemId,
userId,
itemName,
itemValue