<div>
<div class="content wysiwyg-content">
Hi<br />
i have an insert that get me this error:<br />
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'load,alerts_values,user_i<wbr />d) VALUES ('3', 'someone@gmail.com', 'load3', '55', '10'' at line 1' in....<br />
<br />
i have this sql:<br />
$testsql = &quot;INSERT INTO alerts_settings (alert_type, emails, load,alerts_values,user_id<wbr />) VALUES ('3', 'someone@gmail.com', 'load3', '55', '10')&quot;;<br />
the actual thing is with variables from the form. but since it gave me the error i tried manual. get the same error.<br />
<br />
what am i missing here?<br />
<br />
best regards
</div>
</div>


Hi
i have an insert that get me this error:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'load,alerts_values,user_id) VALUES ('3', 'someone@gmail.com', 'load3', '55', '10'' at line 1' in....

i have this sql:
$testsql = "INSERT INTO alerts_settings (alert_type, emails, load,alerts_values,user_id) VALUES ('3', 'someone@gmail.com', 'load3', '55', '10')";
the actual thing is with variables from the form. but since it gave me the error i tried manual. get the same error.

what am i missing here?

best regards

mysql insert doesn't work

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.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.