如何获取'while'的值以包含数组唯一

table:

fungi  |  fruit  |  country

fungi-a       Aple, Orange, Grape,               Japan, America, China, Australia,

fungi-b       Aple, Watermelon, Grape,           Korea, America, China,

fungi-c       Aple, Watermelon, Orange,          Korea, Canada, China, America

fungi-d       Aple, Grape, Orange,               Japan, Canada,

include"config.php";

$result = mysql_query("SELECT * FROM `table` WHERE `fruit` LIKE
'%aple%' AND `country` LIKE'%korea%'");

function asd(){

 while($row=mysql_fetch_array($result)){

 echo $row['country'];

 } } echo implode(',',array_unique(explode(',',asd())));

value is: Korea, America, China, Korea, Canada, China, Amerika

but i want this value: Korea, America, China, Canada,

i make array_unique explode but not worked,

You are not returning any value at asd()

This should work:

function asd() {
    $result = mysql_query("SELECT * FROM `table` WHERE `fruit` LIKE '%aple%' AND `country` LIKE'%korea%'");
    $countries = array();
    while($row=mysql_fetch_array($result)) {
        $countries = array_merge($countries, explode(',', $row['country']));
    }
    return array_unique($countries);
}
echo implode(',', asd());

This will put every 'country' record in the $countries array and return it.

You may also should take a look at OOP and PDO (PHP Data Objects) or MySQLi (MySQL improved).

Try it

include"config.php";

$result = mysql_query("SELECT * FROM `table` WHERE `fruit` LIKE
'%aple%' AND `country` LIKE'%korea%'");

function asd(){

    $myarr = array();

    while($row=mysql_fetch_array($result)){

      if (!in_array($row['country'], $myarr)) {
        $myarr[] = $row['country'];
      }

    }
    return $myarr;
} 

echo implode(",", asd());