PHP help needed

gnomer

Hi,

I have a problem and I don't know how to even approach it.

I have an array that goes like this:

Adam
Peter
Adam
Peter
Peter
Micheal

What I want PHP to do is total the number of duplicates each name has and place them in order, the ones with the most duplicates first.

So the end array would be:

Peter
Adam
Micheal

There were 3 Peter's in the original array, so he goes first, 2 Adam's so he's second an one micheal, so he's last.

How would I go about doing this?

Thanks!

gnomer

So nobody can even point me in the right direction?

Liam Byrne

$arr=array("Adam","Peter","Adam", etc.....
$removedDuplicates=array_unique($arr);

$number_of_duplicates=count($arr)-count($removedDuplicates);

gnomer

Liam Byrne wrote: »

$arr=array("Adam","Peter","Adam", etc.....
$removedDuplicates=array_unique($arr);

$number_of_duplicates=count($arr)-count($removedDuplicates);

Yes, I know that, but it still doesn't help my problem, But many thanks for trying.

Liam Byrne

Sorry - misread the question; try this:

http://answers.yahoo.com/question/index?qid=20071107135746AA64EXq

gnomer

Liam Byrne wrote: »

Sorry - misread the question; try this:

http://answers.yahoo.com/question/index?qid=20071107135746AA64EXq

Many thanks for that, that helped me a lot. But even if I know how many occurances there are of a certain name how am I going to organise the ones with the most first in a new array?

I would need to know which name has the smallest duplicates and which has 2nd smallest etc.

Thats my main problem.

Adam

gnomer wrote: »

Many thanks for that, that helped me a lot. But even if I know how many occurances there are of a certain name how am I going to organise the ones with the most first in a new array?

I would need to know which name has the smallest duplicates and which has 2nd smallest etc.

Thats my main problem.

http://ie2.php.net/count

Liam Byrne

gnomer wrote: »

Many thanks for that, that helped me a lot. But even if I know how many occurances there are of a certain name how am I going to organise the ones with the most first in a new array?

I would need to know which name has the smallest duplicates and which has 2nd smallest etc.

Thats my main problem.

Put the results into an array and sort the resulting array....

function findDuplicates($data,$dupval) {
$nb= 0;
foreach($data as $key => $val)
if ($val==$dupval) $nb++;
return $nb;
}

$arr=array("Adam","Peter","Adam", etc
$arr2=array();

foreach ($arr as $k=>$v) {
if (!(isset($arr2[$k]))) $arr2[$k]=0;
$arr2[$k]=findDuplicates($arr,$v);
}

sort($arr2);

gnomer

I'm not sure if its something I did, but can anyone check this code? its still not working correctly.

NOTE: its already connected to mysql database, if I echo $arr it is correct
[PHP]
<?php

function findDuplicates($data,$dupval) { //this function finds duplicates
$nb= 0;
foreach($data as $key => $val)
if ($val==$dupval) $nb++;
return $nb;
}


$result = mysql_query("SELECT `name` FROM `blah`"); //get the names
$arr=array(); // create $arr


while($row2=mysql_fetch_assoc($result)) //put them in an array, $arr
{
$arr[]=$row2;
}
print_r($arr);

$arr2=array(); //create $arr2

foreach ($arr as $k=>$v) { // fix them all out
if (!(isset($arr2[$k]))) $arr2[$k]=0;
$arr2[$k]=findDuplicates($arr,$v);
}

sort($arr2); // sort them


print_r($arr2); //print it

?>[/PHP]

Webmonkey

Why don't you use SQL to do the sorting automatically for you? or must you do with in PHP.

gnomer

Webmonkey wrote: »

Why don't you use SQL to do the sorting automatically for you? or must you do with in PHP.

I'm not sure exactly how I would do it in the SQL query, It doesnt have to be in PHP.

But thats a good idea tho, if anyone can help me do it either way I would appreciate it.

Webmonkey

SELECT name, count(*) as number FROM `blah` group by name order by number DESC

Then you will get back 3 rows, 2 columns 'name' and 'number' - but you can ignore the number column.

gnomer

Many thanks! I have it working now!

Webmonkey

Good stuff