September 23rd, 2001, 12:46 PM
user regn & maillist table structure
i am trying to create a user registration form & a mailing list system for my site. for this i have to get the interests of the visitor. suppose i have the following interests in a check box form:
* web development
* entertainment (music movies)
how should i store the above data in a database? the options i formulated r:
1. use separate columns for each head. if a person shows interest in linux, that column
should store 'y', otherwise 'n'.
2. use single column for this head. if a person has interest in linux & entertainment,
both should be added to this column. the problem with this method is that if i am
sending newsletter for linux users alone, will it be easy to process this database?
based on extensibility and speed, please tell me of a suitable table structure...