ASP Wish List

[wide_eyed]

Ok, I need some opinions. I'm putting together a wish list script and I want to know if you'll think it would be better to have it as its own table or include it into the user profile. Or if you have a better idea, please share.

tblWish
ID | username | part# | part# | etc..
-------------------------------------
# |name here | 1 | 0 | 1 for yes 0 for no

or within the user profile

ID | username | email | etc... | part# | part# | ect...

or some other way?

[wmif]

should be in its own table using the username or userid as a reference to your user table. you shouldnt however have a column for each part no matter which table you use. easy way would be to setup an auto-incremented index column in the wishlist table, then put the username in each row. only have one part# column and then your query would just select all rows that have a certain username in that column.