IP Search/Compare

[Altair]

Hi, i have a site where i have users sign up..
Its getting to about 100 ppl so far..
So i started thinking in my Admin Panel i need a way to search for IP (to show users who has that IP)
And it should show me who has those IP's
The info is in the MySql Db but i hate going on there to search and compare :p

So the users are in $userrow and the ip would then be $userrow["ip"]
now for the search.. thats where YOU come in :p as im not totally PHP proficient yet hehe.

[The_Chancer]

$sql = mysql_query("SELECT * FROM `tablename` WHERE ip='".$ip."'");
while($info=mysql_fetch_assoc($sql))
{
     print_r($info);
     echo "<br />";
}

That will produce an array of those rows with the same IP as in the var $ip