is there a quick way to compare the results from two arrays and note the diffences?

is there a quick way to compare the results from two arrays and note the differences?

I have two identical tables in MySql (backup and current table) and I want to work out the differences between them (i.e. what
fields are different). I could construct some long function, but I was wondering if anyone had a quick method (I am just learning
PHP).

Thank you


- Nicolaas

In comp.lang.php windandwaves <winandwaves@coldmail.com> wrote:[color=blue]
> is there a quick way to compare the results from two arrays and note the differences?[/color]

That's an RTFM, see http://www.php.net/manual/en/ref.array.php for all
the array functions.
[color=blue]
> I have two identical tables in MySql (backup and current table) and I want to work out the differences between them (i.e. what
> fields are different). I could construct some long function, but I was wondering if anyone had a quick method (I am just learning
> PHP).[/color]

Differences in database tables should be computed by the database
itself if possible.

BTW set your width to something beneath 80 to keep you articles
readable.

On Wed, 23 Mar 2005 17:34:46 +1200, "windandwaves" <winandwaves@coldmail.com>
wrote:
[color=blue]
>is there a quick way to compare the results from two arrays and note the differences?
>
>I have two identical tables in MySql (backup and current table) and I want to work out the differences between them (i.e. what
>fields are different). I could construct some long function, but I was wondering if anyone had a quick method (I am just learning
>PHP).[/color]

[alt.html removed from crosspost as this is entirely offtopic there. It's
tenuous in comp.lang.php since you haven't mentioned PHP...]

If you have the data in an array, then:
http://uk2.php.net/array_diff

But if you're comparing data, I particularly like the Perl Algorithm::Diff
module.
http://search.cpan.org/~tyemq/Algori...orithm/Diff.pm

Try comp.lang.perl.misc or comp.lang.perl.modules if you like the look of
that.

--
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool