mutawari 0 Newbie Poster

hello dear all,
need some advice and help here.PLEASE HELP..

i use jsp page to input same value to mysql table. i have several tables inputed the same way(use jsp).
Then, i show this table with jsp page (this is the same data i inputed to mysql tables).i named it "value_name" table.

| value_code | code_name | value1 | value2 | value3 |
|   123      |  daniweb  |   A    |    B   |   C    |

in the same page above i put a form with the same way to input data. but i want to compare the value i add now with the value_name table above. then the RESULT is if value1(value_name table above) is the same value with the value i just input will result new value in a new row like this : ( i want it look like this )

| new_value1 |   A   |  true  | 2,5 |
| new_value2 |   A   |  false |  0  |
| new_value3 |   C   |  true  | 2,5 |
|  result    |                |  5  |

new_value1 "true" because it is equals with the value1 in value_name table. and the same way with new_value2 and new_value3. i awarded true with 2,5 points. and false with 0 point. after all i want to have sum of all points i had in the result row.

i need some help..what code should i use?
should i use javascript? or jquery? or i use mysql query inside my jsp page?
or there is another way to solve this problem?

thank you,
regards


mutawari