[RESOLVED] Get totals from table

[MitchEvans]

I have 49 fields in my table numbered 1 to 49.

They each have a value in of 1 or 2.

A 1 is a pass and a 2 is a fail.

I want to be able to count up all the 1's in that row?

So here is a row:

1,2,1,2,2,2,2,1,1,1,2,1,2,1,2

I would want the value to return 7 as there are 7 1's and 8 2's

How do I do this please?

[leatherback]

You'd best modify the design of your table so you have 49 rows. Read up on database normalisation.

Anyhoe..

// in the while loop:
$total =0;
foreach($row as $key=>$value)
  {
  $total = $total + $value;
  }
echo $total;

[MitchEvans]

So ytou are saying that instead of having 49 fields I need to have 49 rows. This doesn't seem to make sense though. I have 49 elemnets that I need to check so they are either get passed or failed and then entered into the table like so.

How would I go about it the other way as i'm unsure.

Thanks for looking.

[leatherback]

The reasoning behind it is simple: Imagine you want to do another test, but this one has 50 elements, or 47. You will then have to rebuild all your routines. Whereas if you add them to a table with 3 fields:
[questionaire][question ID][answer/score]
you can keep all your routines, and just change the form.

J.

[MitchEvans]

Thanks a lot for the help your coding above produced the best output, exactly waht I wanted.

Great help as usual from this forum!

Cheers

Mitch.🙂