mysql finding duplicates

[ggkfc]

ive got ppl's ips saved in the addr field (table = users) and i want to find those with same ips and print them in a table, is there something im doing wrong?

 

$rs = query("select addr, count(addr) as num from users group by addr having (count(addr) > 1)");

    echo "<table><tr><td>addr</td><td>count</td></tr>";

    while(list($addr, $count) = mysql_fetch_array($query))

    {

    echo "<tr><td>$addr</td><td>$count</td></tr>";

    }

    echo "</table>" 

[rajivgonsalves]

your query should be

 

select count(*) as num,addr from users group by addr having count(*) > 1

[dewey_witt]

Is this something like what your asking for?

<?php
$rs = query("SELECT DISTINCT fieldname, id FROM table";
?>

[ggkfc]

im not sure, basically searching through their ips and finding if they have got the same ip in two accounts = ban :S

 

thanks for the posts, i tried rajvs but it sadly doesn't work

perhaps my loop thing is wrong as well?

[ggkfc]

bump