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

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

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.

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

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