Hey im trying to do the following in PHP:

Connect to 2 different databases, one named complete and one
incomplete.

My goal is to find whats missing in the "incomplete" database.

The fields i want to compare in the database/table is named 'name' in
both. This field is comtaining unique names

How would you guys do that? arr1 vs arr2 compare or maybe some left
join sql?
I want to output the diff to screen.

Anyone can show me a sample, to get me in the right direction?

Thanks in advance
Jan