php code to solve this i am new to php.I have 2 tables named "registration" table and "first_allotement" table : Please can anyone help me out with php code to solve this i am new to php.I have 2 tables named "registration" table and "first_allotement" table 

'registration' Table:

Altno | pid | appno | name | college1 | college2 | college3 | college4	| college5 | college6 | college7 | college8 | college9 | college10


'first_allotement' Table:

Altno | appno | name | college | curdate | markdate | total | pdf

I need to empty the fields 'college1','college2'.....'college10' in 'registration' table, only if the 'college' field in 'first_allotement' table data is same as to any of the 'college1' or 'college2'....fields in registration table here datas from both tables are selected according to 'appno' field of both table  
