ip address and db

[darknuke]

I am creating a users online script and I need to be able to compare IP addresses. However, when an IP address is added to the db it only uses the first set of numbers of it. (127 of 127.0.0.1 in my case) When I print $user_ip it appears as 127.0.0.1, but in the db it's only 127. Whats wrong? 🙁

$user_ip = $REMOTE_ADDR; // IP address variable
$insert_query = "INSERT INTO {$db_table} (ip, timestamp) VALUES ('{$user_ip}', '{$timestamp}')";
if (mysql_num_rows(mysql_query($exists_query)) == 0) {
 mysql_query($insert_query);
}

[superwormy]

Whats the field type for the database?

I'm willing to bet that the field type is INT or something similar, and since 127.0.0.1 is NOT a valid integer... it truncates to 127.

[darknuke]

Oops... 😃 That was the problem.

[php4geek]

if you want to store it as a number, make it a BIGINT(32), then use PHP's ip2long( ... ) function. read more about it in the php manual. hope this helps