Comparing array items

[the_oliver]

Hello,

 

Im trying to build a function that will show me all the items that are in an array (called $source) but not in another (called $host), and then put the results into a third array (called $diffs).

 

At the moment however it is showing that none of the items in the first array are in the second, when in reality the arrays are identical at present.

 

My code is:

 

 

function compare_data_sets($table,$uvalue) {

   global $host_pg_connection;
   global $source_pg_connection;

   $host_query = "SELECT ".$uvalue." FROM ".$table;
   $host_result = pg_query($host_pg_connection, $host_query);
   $host = pg_fetch_array($host_result);

   $source_query = "SELECT ".$uvalue." FROM ".$table;
   $source_result = pg_query($source_pg_connection, $host_query);

   $diffs = array();

   while($data = pg_fetch_array($source_result)) {
      if( in_array($data[$uvalue], $host) ) {
      }
      else {
        $diffs[] = $data[$uvalue]; 
      }
   }

   print_r($diffs);
}

 

 

Any suggestions where im going wrong?

 

Many Thanks.

[JasonLewis]

There's a function that gets the differences for you, array_diff.