How to compare two fields, from 2 tables in 2 different databases ?

[alter.fire]

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

[Mike Lahey]

Re: How to compare two fields, from 2 tables in 2 different databases?

alter.fire wrote:

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

Not too hard to do in php... Make 2 arrays with the names and array_diff
them.

[iTech7.com]

Re: How to compare two fields, from 2 tables in 2 different databases?

On May 12, 6:26 am, Mike Lahey <mikey6...@yaho o.comwrote:

alter.fire wrote:

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

>
Not too hard to do in php... Make 2 arrays with the names and array_diff
them.

I don't think it displays a nice difference ?

[Jerry Stuckle]

Re: How to compare two fields, from 2 tables in 2 different databases?

alter.fire wrote:

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
>

I'm assuming you're using MySQL - just because most people here are. If
so, you don't even need PHP. Try comp.databases. mysql for a SQL only
solution.

--
=============== ===
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attgl obal.net
=============== ===