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