Storing duplicate checkbox values
| From: | John Starkey | Date: | Thu, 17 May 2001 00:42:44 +0000 |
| Subject: | Storing duplicate checkbox values | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9386@lists.php.net to get a copy of this message | ||
Ok This one has me stumped.
I'm working on a survey for an author. There is already a total of 35
questions and their corresponding columns in the main table. She has three
other questions that have identical checkboxes, 30 each. I want to put
them in the second table and just make reference to the record_id from the
main table and the question number, so that I don't end up with 90 columns
in this second table.
Anyone have any suggestions on a quick way to do this? Obviously the
checkboxes will need to have unique names, but the columns won't. I'm
pretty fried on this and ready to take the not so efficient route of
having 90 columns.
This is a MySQL/PHP4 job.
Thanks,
John