View Single Post

  #3 (permalink)  
Old 05-12-2008
iTech7.com
 
Posts: n/a
Default Re: How to compare two fields, from 2 tables in 2 different databases?

On May 12, 6:26 am, Mike Lahey <mikey6...@yahoo.com> wrote:
> 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 ?
Reply With Quote