[zodehala]

i assign approximately 1000 record into an array called $x

how can i list duplicate record in array ?

[wirehopper]

Use array_unique http://us3.php.net/manual/en/function.array-unique.php, then compare the length of the array_unique with the original array. If they are different, there are duplicates and you could use array_diff http://us3.php.net/manual/en/function.array-diff.php to find them.

[Keith]

You could also use array_count_values(), arsort(), and array_diff():

PHP Code:

// dummy values
$vals = array(
    'One',
    'Two',
    'Three',
    'Four',
    'Five',
    'One',
    'Two',
    'Three',
    'Two',
    'Three',
);

// get number of instances per value
$vals = array_count_values( $vals );

// sort values by count from most frequent to least
arsort( $vals );

// optional, removes all values that appear only once
$vals = array_diff( $vals, array( '1' ) );

print_r( $vals ); 

...will output:

Code:

Array
(
    [Two] => 3
    [Three] => 3
    [One] => 2
)

[zodehala]

İ can list users in db using following

PHP Code:

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

    echo $row["username"];

} 

i can list duplicate record in array using following

PHP Code:

$array = array('a', 'b', 'a', 'a', 'c', 'a', 'd', 'a', 'c', 'd','e','e','e','e','e','e','e','e','e','e','e','e');

$answer = array_count_values($array);

$i=0;

foreach($array as $value){

    if($answer[$array[$i]] >2){

        echo $value.$answer[$array[$i]]."<br/>";

    }

    $i++;

    

} 

how can i merge both of them ? ( i tried but i can not)

[wirehopper]

Maybe this will help:

PHP Code:

$array=array();

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

    $array[]=$row["username"]; 

}