O'brien5

This project is a prototype of a school admission system where by we can just import in the table of results from the examinations board database into the school admission database. So having already results from the applicants in one table structured to be identical with the imported table, we just compare the two tables to check who is faking results by comparing if "grades" are identical for simillar composite primary key ("index_number" and "subject"). I real thank you for taking the time to look into it. I appreciate.

Thanks for the reply larry. Yes I still need your help.

Larry I like reading your forums and tutorials though am a newbie, using your yii tutorials I have been able to build an online admission application in a small period of time. I have two tables in my database which I want to use to select applicants who submitted valid results. The first table (HS_results) has attributes((index_number, subjects)pk , grade, valid) which contains results entered by the applicant. The second table(Exams_Board_results) which has the same structure as the first table( minus valid) but its data is already populated with the results from the exams board. I want to build a function that checks that for every row in first table has the same grade with a row in the second table if the primary key is the same for matching rows let the attribute "valid" =1 otherwise 0 . And lastly. I already have Cgridview for. first table . how can I implement that function so that the values for valid automatically show in the gridview