CODEWITHSUNDEEP
phpmysqli
Darkness
Darkness

Reputation: 103

Error with MySQLi INSERT

I have ths query, again i'm trying to pass from pop3 account to mysql database:

mysqli_query($con,"INSERT INTO procesa_emails (body_mail, uid_message, fecha, from, to, subject, message_id) VALUES ('".mysqli_real_escape_string($con,htmlentities(str_replace("'","",str_replace('"','',$message))))."','".mysqli_real_escape_string($con,htmlentities($uid_mess))."','".mysqli_real_escape_string($con,htmlentities($fecha))."','".mysqli_real_escape_string($con,htmlentities($from))."','".mysqli_real_escape_string($con,htmlentities($to))."','".mysqli_real_escape_string($con,htmlentities($subject))."','".mysqli_real_escape_string($con,htmlentities($mui))."')")or die(mysqli_error($con));

But It returns me:

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 'from, to, subject, message_id)

I tried with str_replace("'","",str_replace('"'.'')) But It also doesn't work

Upvotes: 0

Views: 54

Answers (1)

Amal Murali
Amal Murali

Reputation: 76666

FROM is a reserved keyword. So, if you want to use that inside your query, you need to wrap it in backticks, like so:

mysqli_query($con,"
INSERT INTO procesa_emails (body_mail, uid_message, fecha, `from`, ...

Hope this helps!

Upvotes: 1

Related Questions