removing duplicated key in multidimensional array...

yenn

Dear all,

I'm trying to remove array with same listing_id in my multidimensional array but it is not working...

The multidimensional array:

array(3) {
	[0]=>
	array(10) {
		["id"]=>
		string(1) "1"
[COLOR="Red"]		["listing_id"]=>
		string(4) "4129"[/COLOR]
		["date"]=>
		string(4) "2009-11-30"
	}
	[1]=>
		array(10) {
		["id"]=>
		string(1) "2"
[COLOR="Red"]		["listing_id"]=>
		string(4) "4129"[/COLOR]
		["date"]=>
		string(4) "2009-11-28"
	}
	[2]=>
		array(10) {
		["id"]=>
		string(1) "4"
		["listing_id"]=>
		string(2) "26"
		["date"]=>
		string(4) "2009-12-02"
	}
}

Code for removing the duplicated key:

$aTemp = $aNew = array();
		foreach($results as $key=>$aVal){
		if(array_key_exists($aVal['listing_id'], $atemp)){
		continue;
		}else{
		$aTemp[$aVal['listing_id']] = 1;
		$aNew[] = $aVal;
		}
		}

Below is the out put of var_dump($aNew);

array(3) {
	[0]=>
	array(10) {
		["id"]=>
		string(1) "1"
[COLOR="Red"]		["listing_id"]=>
		string(4) "4129"[/COLOR]
		["date"]=>
		string(4) "2009-11-30"
	}
	[1]=>
		array(10) {
		["id"]=>
		string(1) "2"
[COLOR="Red"]		["listing_id"]=>
		string(4) "4129"[/COLOR]
		["date"]=>
		string(4) "2009-11-28"
	}
	[2]=>
		array(10) {
		["id"]=>
		string(1) "4"
		["listing_id"]=>
		string(2) "26"
		["date"]=>
		string(4) "2009-12-02"
	}
}

Do I make any mistake in the code? Or is there any other better way to get my problem solved?

dagon

foreach($results as $key=>$aVal){

if (!in_array($aVal['listing_id'],$existing)){
			$aNew[]= $aVal;
}
$exisiting[]=$aVal['listing_id'];
}

bpat1434

You forgot to unset() the original array's key. I've marked the new code with comments:

$aTemp = $aNew = array();
foreach($results as $key=>$aVal){
	if(array_key_exists($aVal['listing_id'], $atemp)){
/** NEW CODE **/
		unset($results[$key]);
/**************/
		continue;
	}else{
		$aTemp[$aVal['listing_id']] = 1;
		$aNew[] = $aVal;
	}
}

Hope that helps.

yenn

Dear dagon & bpat1434,

Thanks a lot for your suggestion.

I have tested both the code, however, it still show the duplicated key.

I'm wondering whether my logic is working.

What I wish to get is:

Before checking:

array(3) {
	[0]=>
	array(10) {
		["id"]=>
		string(1) "1"
		["listing_id"]=>
		string(4) "4129"
		["date"]=>
		string(4) "2009-11-30"
	}
	[1]=>
		array(10) {
		["id"]=>
		string(1) "2"
		["listing_id"]=>
		string(4) "4129"
		["date"]=>
		string(4) "2009-11-28"
	}
	[2]=>
		array(10) {
		["id"]=>
		string(1) "4"
		["listing_id"]=>
		string(2) "26"
		["date"]=>
		string(4) "2009-12-02"
	}
}

After checking:

array([B]2[/B]) {
	[0]=>
	array(10) {
		["id"]=>
		string(1) "1"
		["listing_id"]=>
		string(4) "4129"
		["date"]=>
		string(4) "2009-11-30"
	}
/***removed***/
[COLOR="Silver"]	[1]=>
		array(10) {
		["id"]=>
		string(1) "2"
		["listing_id"]=>
		string(4) "4129"
		["date"]=>
		string(4) "2009-11-28"
	}[/COLOR]
/***removed***/
	[[B]1[/B]]=>
		array(10) {
		["id"]=>
		string(1) "4"
		["listing_id"]=>
		string(2) "26"
		["date"]=>
		string(4) "2009-12-02"
	}
}

dagon

$a=array(array('listing_id'=>'4129'),array('listing_id'=>'4122'),array('listing_id'=>'4129'));
$exisiting=array();
foreach($a as $key=>$aVal){

if (!in_array($aVal['listing_id'],$exisiting)){
			$aNew[]= $aVal;
}
$exisiting[]=$aVal['listing_id'];
}

print_r($aNew);

yenn

dagon;10935574 wrote:

$a=array(array('listing_id'=>'4129'),array('listing_id'=>'4122'),array('listing_id'=>'4129'));
$exisiting=array();
foreach($a as $key=>$aVal){

if (!in_array($aVal['listing_id'],$exisiting)){
			$aNew[]= $aVal;
}
$exisiting[]=$aVal['listing_id'];
}

print_r($aNew);

Thanks again dagon...

Can I say if I want to get the other values printed such as id & date, I need to perform an another step by checking the latest $aNew with the previous $result to get the below result printed?

array(2) {
	[0]=>
	array(10) {
		["id"]=>
		string(1) "1"
		["listing_id"]=>
		string(4) "4129"
		["date"]=>
		string(4) "2009-11-30"
	}
	[1]=>
		array(10) {
		["id"]=>
		string(1) "4"
		["listing_id"]=>
		string(2) "26"
		["date"]=>
		string(4) "2009-12-02"
	}
}

So in conclusion, the step will be like this:
1. Get all the listing_id out from the $result.
2. Perform the checking as you shown me here.
3. Get the set of data out from listing_id if the listing_id matches listing_id in $aNew

Am I correct?

dagon

I'm really unclear what you want at this stage.

yenn

dagon;10935576 wrote:
I'm really unclear what you want at this stage.

Sorry for my poor expression here...

The condition is like this:

I got the arrays from 2 search:

$result1=mysql_query("select * from listing where title='%".$keyword."%'");

$result1 will generate data such as:

array(2) {
  [0]=>
  array(93) {
    ["id"]=>
    string(2) "26"
    ["listing_id"]=>
    string(2) "26"
    ["last_modify"]=>
    string(2) "2009-09-20"
  }
  [1]=>
  array(93) {
    ["id"]=>
    string(4) "4129"
[COLOR="Red"]    ["listing_id"]=>
    string(4) "4129"[/COLOR]
    ["last_modify"]=>
    string(2) "2009-11-28"
  }
}

$result2=mysql_query("select * from product where product_name='%".$keyword."%'");

$result2 will generate data such as:

array(2) {
  [0]=>
  array(93) {
    ["id"]=>
    string(2) "288"
    ["listing_id"]=>
    string(2) "288"
    ["last_modify"]=>
    string(2) "2009-10-20"
  }
  [1]=>
  array(93) {
    ["id"]=>
    string(4) "4129"
[COLOR="Red"]    ["listing_id"]=>
    string(4) "4129"[/COLOR]
    ["last_modify"]=>
    string(2) "2009-09-30"
  }
}

So the search result will be:

$result=$result1.$result2;

However, I don't want to echo the same data twice as you see the both results contains listing_id = 4129

So i thinking is there any way I can remove the duplicated data from the merged array $result

I'll keep trying for the solution and hope to update the status here later.

Thank you!

dagon

there's the real problem, it can be done with one query.

yenn

dagon;10935579 wrote:
there's the real problem, it can be done with one query.

Thanks for your sharing dagon, I'll work hard for the solution 🙂

dagon,

really appreciate for your sharing...

bpat1434

FYI yenn, there was a syntax error I didn't catch in your original post. If you look inside your foreach loop at the if statement. You use "$atemp" while you pre-define "$aTemp". PHP variables are case sensitive.

Now, that's not to say you don't have a larger problem in that you're running two queries when you could be running one.

johanafm

yenn;10935575 wrote:
Thanks again dagon...
Can I say if I want to get the other values printed such as id & date, I need to perform an another step by checking the latest $aNew with the previous $result to get the below result printed?

If I'm not totally confused as to what you say, you haven't understood what Dagon's code does. It does take each element from the top level array if there is not allready a matching listing_id in previously selected array elements.
That his example array contains nothing but listing_id doesn't matter. Try it with

$a=array(array('listing_id'=>'4129', 'other_stuff' => 'whatever'),array('listing_id'=>'4122', 'other_stuff' => 'whatever again'),array('listing_id'=>'4129', 'other_stuff' => 'whatever three'));