bank reconciliation

I am working on a bank reconciliation project.

I imported two excel files into tables in a database as I'm using mysql.table-1 and table-2.

I want to compare the values in both tables开发者_Go百科 and the mismatched values in one table should be added in another table so that values are balanced and print out the mismatches in the respective tables.

Can any one help to do this with PHP ?

These functions should do what you need

Connect to a database. If you don't have PDO and can't get it use mysql_connect.

Since you don't have user input you can use PDO::query or mysql_query to retrieve the records.

== or === will compare results from each table.

To insert use PDO::exec or mysql_query.

I think that that should be enough to start you off.