Remove duplicates in Arrays from MYSQL query and then insert into another table

Question

I have the code below to query a table which retrieves arrays. The parameter $idList could have several values and may therefore produce duplicates. I am only interested in inserting one unique memalertid.

Any advice on how to remove the duplicates would be much appreciated.

$sql = mysql_query("SELECT  memalertid from memlist where listID IN ($idList) AND (emailyes = '1') ");
while ($info = mysql_fetch_array($sql)){
$insert_query = "insert into subsalerts (memalertid, idMembers, emailid) VALUES('".$info['memalertid']."','$idMembers','$emailid')";
$insert_buffer = mysql_query($insert_query);

Thanks very much

Francois Deschenes · Accepted Answer · 2011-06-28 18:08:53Z

4

Simply use SELECT DISTINCT to select distinct rows.

SELECT DISTINCT memalertid FROM memlist WHERE listID IN ($idList) AND (emailyes = '1')

You could also GROUP BY memalertid instead.

SELECT memalertid FROM memlist WHERE listID IN ($idList) AND (emailyes = '1') GROUP BY memalertid

For more information: http://dev.mysql.com/doc/refman/5.5/en/select.html.

edited Jun 28, 2011 at 18:08

answered Jun 28, 2011 at 18:02

Francois Deschenes

25.1k4 gold badges67 silver badges61 bronze badges

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

Comments

grep · Accepted Answer · 2011-06-28 18:02:28Z

2

$newArray = array_unique($yourArray);

This will create a new array only with unique values; excluding any duplicates.

answered Jun 28, 2011 at 18:02

grep

4,0368 gold badges47 silver badges67 bronze badges

Comments

Balanivash · Accepted Answer · 2011-06-28 18:05:25Z

2

You can use group by clause to group the results with the same id, so that you'll get only unique ids

answered Jun 28, 2011 at 18:05

Balanivash

6,8919 gold badges34 silver badges48 bronze badges

Comments

dtbarne · Accepted Answer · 2011-06-28 18:05:59Z

0

No need to get PHP involved. Just SELECT using GROUP BY.

INSERT INTO subsalerts (memalertid, idMembers, emailid)
    SELECT memalertid, $idMembers, $emailid FROM memlist WHERE listID IN ($idList) AND emailyes = 1 GROUP BY memalertid;

answered Jun 28, 2011 at 18:05

dtbarne

8,2505 gold badges47 silver badges49 bronze badges

Collectives™ on Stack Overflow

Remove duplicates in Arrays from MYSQL query and then insert into another table

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related