PHP Array Duplicates

Question

my first post here and hoping someone can help. I am querying a table in a mySQL DB, and obviously getting the results. However, the table is used to store multiple entry by one user for the purpose of user contacts.

What I would like to do is display each user individually, and count the number of contacts each user has. I had a look at the post "How to detect duplicate posts in PHP array, which helped a bit, but I am still stuck.

Please see my code for the query below, I have left out the array duplicate part as it is a pretty mess at the moment.

<?php
    $result = mysql_query("SELECT * FROM vines");
    while($row = mysql_fetch_array($result)) {
        $results=$row['vinename'];
        echo $results;
        echo "<br />";
    }
?>

This result returns the below, obviously these are records from the vinename coloumn.

Marks Vine<br />
Marks Vine<br />
Marks Vine<br />
Tasch Vine<br />
Tasch Vine<br />

Regards Mark Loxton

Please fix your code formatting. There's a preview box under the editing box you can use to see if it looks reasonable. — Jani Hartikainen
– Jani Hartikainen, Commented Oct 28, 2009 at 18:24
whats your expected output? even if it is messy, can i see the array duplicate part? — cp3
– cp3, Commented Oct 28, 2009 at 18:25
So for this you want a list of the users and the count of how many times the user ("vinename") is listed? So for your example: "Marks Vine, 3; Tasch Vine, 2" ? Is that right? — artlung
– artlung, Commented Oct 28, 2009 at 18:26

ceejayoz · Accepted Answer · 2009-10-28 18:28:14Z

1

Hi there, my first post here and hoping someone can help. I am querying a table in a mySQL DB, and obviously getting the results. However, the table is used to store multiple entry by one user for the purpose of user contacts.

You can do this in the query itself a lot more easily than in the PHP code afterwards.

SELECT name, COUNT(id) AS count FROM vines GROUP BY name

answered Oct 28, 2009 at 18:28

ceejayoz

181k42 gold badges311 silver badges382 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jitter · Accepted Answer · 2009-10-28 18:28:43Z

1

Just change the SQL Query to

SELECT vinename, COUNT(vinename) as counter FROM vines GROUP BY vinename

and then do

echo $row['vinename']." #".$row['counter']."<br />";

answered Oct 28, 2009 at 18:28

jitter

54.8k11 gold badges114 silver badges130 bronze badges

1 Comment

Mark Over a year ago

Hi there, firstly thank you everyone for such awesome input. I seriously did not expect such a quick response. I am seriously greatful. The above worked like oil in an engine.

EToreo · Accepted Answer · 2009-10-28 18:28:12Z

0

I would run two types queries... 1) Select each UNIQUE user from vines. 2) For each user in that set, run a second COUNT query against that user's id in the table "vines".

I hope that helps.

answered Oct 28, 2009 at 18:28

EToreo

3,1164 gold badges32 silver badges36 bronze badges

2 Comments

artlung Over a year ago

As other answers indicate, this can be done in a single query using the GROUP BY clause.

EToreo Over a year ago

You should probably try to use the GROUP BY clause instead. it is a better solution.

Ivan Nevostruev · Accepted Answer · 2009-10-28 18:28:20Z

0

You can create a separate array to store records you've already output there.

<?php
$result = mysql_query("SELECT * FROM vines");

$duplicates = array(); ## store duplcated names here
while($row = mysql_fetch_array($result)) {
    $results = $row['vinename'];

    if (!array_key_exists($results, $duplicates)) {
        echo $results;
        echo "<br />";
        $duplicates[$results] = 1; ## mark that we've already output this records
    }
}

?>

answered Oct 28, 2009 at 18:28

Ivan Nevostruev

28.9k8 gold badges69 silver badges82 bronze badges

Comments

Vinicius Jarina · Accepted Answer · 2009-10-28 18:31:56Z

0

You can try, change your query to use count and group of SQL.

Somoe thing like

$result = mysql_query("SELECT count(*) as total,name FROM vines GROUP by name");

answered Oct 28, 2009 at 18:31

Vinicius Jarina

8175 silver badges17 bronze badges

Comments

Jason Plank · Accepted Answer · 2011-03-10 23:06:56Z

0

firstly thank you everyone for such awesome input. I seriously did not expect such a quick response. I am seriously grateful.

I used the recommendation from Jitter. I have pretty much been going through so many variations of the above code today, but just needed that missing piece.

Thanks, everyone. Below is what the final code looks like for anyone else who has the same problem in the future.

<?php

$result = mysql_query("SELECT vinename, COUNT(vinename) as counter FROM vines GROUP BY vinename ORDER BY counter DESC LIMIT 0, 3");
while($vinerow = mysql_fetch_array($result))

echo $vinerow['vinename']." has ".$vinerow['counter']." tomatos."."<br />";

?>

edited Mar 10, 2011 at 23:06

Jason Plank

2,3325 gold badges32 silver badges40 bronze badges

answered Oct 28, 2009 at 20:03

Mark

11 bronze badge

Comments

Amirshk · Accepted Answer · 2009-10-28 18:28:58Z

-1

change your query to:

SELECT distinct * FROM vines

answered Oct 28, 2009 at 18:28

Amirshk

8,2682 gold badges38 silver badges64 bronze badges

2 Comments

ceejayoz Over a year ago

Doesn't give counts, and it also wouldn't work if other data in the row isn't identical.

Mark Over a year ago

Thanks, as this has been my problem for the day, I have been going through everyones answer, and they all worked great.

Collectives™ on Stack Overflow

PHP Array Duplicates

7 Answers 7

Comments

1 Comment

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

1 Comment

2 Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related