MYSQL Logic question

[godsent]

OK here is what I'm trying to do.

 

Where is row in my database with IP's which they are separated with space between. Ex: 127.0.0.1 127.0.0.2 127.0.0.3...

 

And I'm trying to write function to check every row, and if in that row where is specified IP +1count. I mean to count how many rows have specified IP.

 

Im not sure how can i do that:

 

function countRows($ip)
{
   $res = mysql_query("SELECT * FROM list WHERE ips = ?????");
   $num_rows = mysql_num_rows($res);
   return $num_rows;
}

 

I have no idea how to do this, please help if you can.

[haku]

mysql_query("SELECT count(ips) WHERE ips LIKE '%" . $ip_address . "%'");

[fenway]

Hope those IP addresses are being stored numerically....

[Mchl]

IP's which they are separated with space between. Ex: 127.0.0.1 127.0.0.2 127.0.0.3...

 

It seems to me that they aren't. One field, multiple IPs stored as string... it doesn't get much worse than that.

[fenway]

Yikes.

[FezEvils]

$ip = 127.0.0.1 127.0.0.2 127.0.0.3

$ip_s= explode (" ",$ip);

//it will remove the space then stored it into array

 

echo $ip_s[0];

echo $ip_s[1];

echo $ip_s[2];

 

to count how may ip in $ip, use $result = count ($ip_s);

[Mchl]

Actually if we want to use MySQL for this, haku's solution would work.

[fenway]

Actually if we want to use MySQL for this, haku's solution would work.

I'd prefer to "wrap" it in the delimeter too, but it's unlikely to be an issue for formatted data like IPs.