What would be a good way to deal with the following... I have a form that has 5 checkboxes on it, lets say the checkboxes are for categories, and more than one can be selected.
For example: please tell is what brochure you want [] car [] boat [] truck [] SUV [] beetle I have been asked to provide statistics on how many total form submissions there are per month. This part seems pretty simple, I just add a new record every time the form is sent. They also want to know stats on which categories were picked as well. I don't know if I should create one table to store just the fact that a form has been posted, and then another to store the 5 above values. I don't see the 5 categories being changed, so I could create 5 fields in one table, and tally them that way, or I could create one field and put the actual value in that field and tally them that way. Any suggestions are appreciated. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
