Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysql from trying to interperate this data and blindly store it ??
Many Thanks
You need to escape the string before you sent it to MySQL to be stored.
The link below is for the C API function; whichever language API you're
using has something equivalent.
http://dev.mysql.com/doc/mysql/en/mysql-real-escape-string.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
