[SOLVED] Storeing an IP address in a db

[Voodoo Jai]

I am trying to store an ip address in a db without success. I have a table and are field defined as an int to store the value, I then are trying to store using  "INET_ATON" like so:

the ip value is 127.0.0.1

$ip=$_SERVER['REMOTE_ADDR']; 

mysql_query("INSERT INTO ipstore (address) VALUES INET_ATON(($ip)") 

 

I  get this msg

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INET_ATON((127.0.0.1)' at line 1

 

how should I be doing this storeage.

 

Thanks advance

Voodoojai

[PseudoEvolution]

The first thing I noticed is the extra "("

 

VALUES INET_ATON(($ip)")

 

Fix that and see if it works.

[Voodoo Jai]

removed the extra "(" but still not working, shows a blank screen now.

[jkewlo]

$ip=$_SERVER['REMOTE_ADDR'];

 

mysql_query("INSERT INTO ipstore ('address') VALUES ('$ip')");

[Voodoo Jai]

That now gives this reply

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''address') VALUES INET_ATON = 127.0.0.1' at line 1

[jkewlo]

$ip = $_SERVER['REMOTE_ADDR'];

 

mysql_query = "INSERT INTO ipstore VALUES inet_aton('$ip')";

try that

 

 

also post all of your code it helps us alot

[Voodoo Jai]

Got it working now this is the code I used:

 

mysql_query("INSERT INTO ipstore (address) VALUES (INET_ATON('$ip'))")

 

instead of

 

mysql_query("INSERT INTO ipstore (address) VALUES INET_ATON(($ip)")

the bracket was at the wrong end as well as one missing, also single quotes in the value list corrected it.

dam typos so frustrating.

 

thans for all your help guys.

[jkewlo]

ah i feel slow i should of known that