Scoring system database design

[Tezread]

So- I have created a form which encompasses checkboxes. Each checkbox has a score value assigned to it and if it is checked the score is stored in an array. (called score[]!!)
I have developed a formhandler based on another thread on this site but there was indicationon how this guy developed their database/form. My question is how do I adapt my form and database design (see below) to coincide with the formhandler approach?

here is my current db design which encompasses a single table named qualityadmin- I have a strong feeling I will need another table called 'score' to handle the array but like I said - im not sure how to design it to suit my formhandler

qualityadmin_id
type_registered_charity
type_incorporated
etc.........
totalscore

here is the form

<td colspan="3"><p>Registered charity</p></td>
                      <td><div align="center">
                          <input name="score[type_registered_charity]" type="checkbox" value="5" />
                      </div></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td colspan="3"><p>Incorporated</p></td>
                      <td><div align="center">
                          <input type="checkbox" name="score[type_incorporated]" value="5" />
                      </div></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td colspan="3"><p>Member of a National or Regional Association (e.g. Alzheimers Society)</p></td>
                      <td><div align="center">
                          <input type="checkbox" name="score[type_regional_association]" value="5" />
                      </div></td>
                    </tr>
                    <tr>
                      <td>&nbsp;</td>
                      <td colspan="3"><p>Branch of a National or Regional Charity (e.g.Barnardos</p></td>
                      <td><div align="center">
                          <input type="checkbox" name="score[type_regional_charity]" value="5" />
                      </div></td>
                    </tr>

etc etc

and here is the formhandler

?php
		include("connect.php");
		$sql = "SELECT SUM(score) AS totalscore FROM qualityadmin";
$getscore = mysql_query($sql, $connection) or die(mysql_error());
$row_getscore = mysql_fetch_assoc($getscore);
$totalRows_getscore = mysql_num_rows($getscore);

while($row_getscore = mysql_fetch_array($getscore))
{
	$score[] = $row_getscore['score'];

echo array_sum($score);
}
 ?>

thx in advance

[fandelem]

this largely depends on if you will have anything in the qualityadmin table besides score information and the unique identifier (qualityadmin_id). Is the answer YES? (ie. a name, email address, etc) Then you want to create a child (detail) table with a link pointing back to the parent (header) table.

qualityadmin table:

CREATE TABLE `qualityadmin` (
`id` INT( 16 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 50 ) NOT NULL ,
`email` VARCHAR( 50 ) NOT NULL ,
`updtts` TIMESTAMP NOT NULL ,
INDEX ( `name` , `email` ) 
) ENGINE = innodb;

and here's your child table:

CREATE TABLE `qualityadmin_dtl` (
  `qualityadmin_id` int(16) NOT NULL,
  `type` varchar(50) NOT NULL,
  `score` int(5) NOT NULL,
  PRIMARY KEY  (`qualityadmin_id`,`type`)
) ENGINE=InnoDB;

so to sum your score, based on say, email:

SELECT SUM(b.score) AS totalscore FROM qualityadmin a, qualityadmin_dtl b where a.email = '[e-mail]' and a.id = b.qualityadmin_id

hth,

kyle

[Tezread]

Thankyou!
- I have some questions in response to your prompt response

what table should the field 'totalscore 'belong to and what properties should it have?-

SELECT SUM(b.score) AS totalscore

if I want to refer to email/qualityadmin_id as a variable how could I express that in the query?

in the qualityadmin_dtl table is the field 'type' refering to the question type in this case
type_registered
type_charity
as well as other checkbox fields such as income_under5k etc etc
if so does this mean I need to migrate these checkbox fields from qualityadmin table to the qualityadmin_dtl table so just fields like email, contact are in qualityadmin and fields type_XXX income_YYYY (checkbox responses) are in qualityadmin_dtl?

i.e

db structure for qualityadmin_dtl

qualityadmin_id INT not null (no auto_increment)
type_registered (value will be from checkbox response)
type_charity (value will be from checkbox response)
income_xxx (value will be from checkbox response)
income_yyy (value will be from checkbox response)
funding_zzzz
score

how is the INSERT query handled for the qualityadmin_dtl table??

and.... is the naming I used for checkboxes correct? i.e

 <input name="score[type_registered_charity]" type="checkbox" value="5" />

or should it be..

<input name="type_registered_charity" type="checkbox" value="5" />

sorry for all the questions!!

[Tezread]

apologies if i have confused you

[Tezread]

perhaps fandelem could contact me by email- I have triedn but there is no email available