i have table answer with colums as answer_id,question_id,student_id,stu_ans,stu_marks.
i want add all marks of particular student
and store in result table
in Result table colums are result_id,student_id,marks.
i will store added marks result table but I don't how to perform addition of marks of particular student and store in integer variable
example i want perform addition of marks where student_id=1