This is a discussion on is there a quick way to compare the results from two arrays and note the diffences? within the PHP Language forums, part of the PHP Programming Forums category; is there a quick way to compare the results from two arrays and note the differences? I have two identical ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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:
> is there a quick way to compare the results from two arrays and note the differences? That's an RTFM, see http://www.php.net/manual/en/ref.array.php for all the array functions. > 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). 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: >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). [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 |