Posted by Good Man on 11/19/26 11:47

Jerry Stuckle <jstucklex@attglobal.net> wrote in
news:MdidneFRIeWFJv_ZRVn-pA@comcast.com:

> guitarromantic@gmail.com wrote:
>> Hey everyone,
>>
>> I run a site with staff-submitted reviews, and most of them are
>> written by one author. However, we also do "multiple" reviews. Up
>> until now I just had a userid for a 'Multiple' account and submitted
>> them under that, but this makes it harder to print lists of all the
>> reviews by one person, so ideally I wanna make a multiple select form
>> so we can just select all the contributors and have the values saved
>> in the database - in one row (something like "56,34,21" etc).

> Another table is definitely the way to go. Conistst of two columns -
> testid and reviewerid - plus anything else you might have specific to
> that reviewer on that test.

Triple recommended. Basically, follow this rule:

If the data you want to store is a list of values seperated by commas (or
any other delimiter), 99% of the time it is ALWAYS better to create
another table (a many-to-many table).

[Back to original message]