There is only one database.
I have got 1 table with the fields qid,qans.
One more table with the fields qid,uans,result.
I want to compare each record of qans and uans and if they match then answer should be 1 and it should store value 1 in result respective row.
If it does'n match then it should store value 0 in the result field of respective row.
How to write this code and where?