<div>
Hi, <br />
The IP is an auto insertion <br />
<br />
In the form : &lt;input type=&quot;hidden&quot; name=&quot;IP&quot; value=&quot;&lt;?php echo $_SERVER['REMOTE_ADDR'] ?&gt;&quot; /&gt;<br />
<br />
And $ip = stripslashes($ip);<br />

</div>


Hi,
The IP is an auto insertion

In the form : <input type="hidden" name="IP" value="<?php echo $_SERVER['REMOTE_ADDR'] ?>" />

And $ip = stripslashes($ip);


<div>
that is not the place where there is the problem.<br />
please show the code that builds up the sql statement
</div>


that is not the place where there is the problem.
please show the code that builds up the sql statement

<div>
you were right!<br />
<br />
the problem was here : IP= $IP&quot;;<br />
<br />
should have been : IP= '$IP' &quot;;<br />
<br />
thanks!
</div>


you were right!

the problem was here : IP= $IP";

should have been : IP= '$IP' ";

thanks!

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
<br />
I keep getting this error while trying to test a php form that insert data into (myisam) mysql database:<br />
&quot;Error entry: 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 '.29.230' at line 9&quot;<br />
<br />
This line refers to IP address. &nbsp;I set the IP data-type to VARCHAR(15). So I am not really sure what's the problem?
</div>
</div>


Hi experts,

I keep getting this error while trying to test a php form that insert data into (myisam) mysql database:
"Error entry: 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 '.29.230' at line 9"

This line refers to IP address.  I set the IP data-type to VARCHAR(15). So I am not really sure what's the problem?

SQL syntax - IP address datatype

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.