PHP query join question.

Question

if i have a table that looks like this:

sample_id   date       sample_number
12          1-24-10    5
09          1-25-10    2
12          2-14-10    5

How can I join both (sample_id:12)'s ?

sample_id:12 has a total of 10 sample numbers.

Answer 1

SELECT SUM(`sample_number`) FROM `table` GROUP BY `sample_id`;

Should do it.