I have two tables and I have to compare the tables data and if data matches that assign the value "Yes" to the column status and if unmatched then assign the value "No" to that status column and i have to do this for multiple values. I need to do this using PHP and display the data in PHP table with the matched value status and unmatched value status.
Thanks in advance.
What I have tried:
I have tried sql query and able to fetch the unmatched values in table but not able to assign the status to matched and unmatched values.