Foreach ($ keywordas $ val) {& nbsp; $ SQL & quot; SelecttitlefromXXXXtitlelike % $ val % limit10 & quot; & nbsp; $ listarray (); & nbsp; $ dsql-& gt; SetQuery ($ s about loop array merging
Foreach ($ keyword as $ val ){
$ SQL = "Select title from XXXX title like '% $ val %' limit 10 ";
$ List = array ();
$ Dsql-> SetQuery ($ SQL );
$ Dsql-> Execute ();
While ($ row = $ dsql-> GetArray ()){
$ List [] = $ row;
}
}
The result is as follows. How can I merge and remove duplicates ..
Array
(
[0] => Array
(
[Title] = & gt; 1111111111
)
[1] => Array
(
[Title] = & gt; 22222222222
)
[2] => Array
(
[Title] = & gt; 333333333333
)
)
Array
(
[0] => Array
(
[Title] = & gt; 1111111111
)
)
------ Solution --------------------
PHP code
$list = array();foreach ($keyword as $val){ $sql="Select title from XXXX title like '%$val%' limit 10 "; $dsql->SetQuery($sql); $dsql->Execute(); $array = array(); while ($row = $dsql->GetArray()) { array_push($array,$row); } $list[] = $array;}print_r($list);