Selecting from db, and showing only the same stuff on a row.

[BittenApple]

Ok, I know how to select from a database, and so I have this

	$showing = mysql_fetch_array(mysql_query("select * from players order by IP"));

Ok, that pulls out the player's IP adresse, now how would I show if 2, or more, players IPs are the same, it ONLY shows them players that have the same ip - and if a player has a unique IP to the database, it doesnt show this.

I want it to show ALL the people with the same IP as another player, so not only 1 IP, but like there could be 2 people with the same IP, then another 2, then 3 people, and I want it to show only those people.. getme?

Thanks to all who help!!

[Nick]

I'm not sure this will work, but it's worth a try...

SELECT * FROM players WHERE COUNT(ip)>1 GROUP BY ip