php mysql REMOTE_ADDR not working

[unwashed potato!]

i'm trying to store the visitors ip address in a mysql table but it's not coming out correclt some reason. this is roughyl what i have...

$ip = $_SERVER['REMOTE_ADDR'];

ip is a varchar in the table.

what i end up with everytime is ::1

am i doing something wrong? my error404 checking emails me the ip address of the user and that is correct so unsure what's making this incorrect.

 

[unwashed potato!]

As above. Just force your web server to operate on IPv4 addresses only.

how would i do that and would it not be better to make the script read IPv6 so it works locally and on the web server?

 

[unwashed potato!]

it isn't hosted but will be. at a guess then as when the file is hosted i get sent emails of 404 errors with the ip address and they come out fine, this will work when hosted aswell?