[PHP] MySQL Problem with PHP

I am using PHP and MySQL on a 2k dev box to be uploaded to a linux box I have a piece of SQL INSERT INTO `contracts` (`key`, `content`) VALUES (1,'blah blah blah character 39 is a single speach mark '+CHAR(39)+' blah blah blah') Instead of inserting: 'blah blah blah character 39 is a single

RE: [PHP] MySQL Problem with PHP

INSERT INTO `contracts` (`key`, `content`) VALUES (1,'blah blah blah character 39 is a single speach mark '+CHAR(39)+' blah blah blah') That's because you are adding strings together, not concatenating them (this isn't javascript!) Use CONCAT() in MySQL to join strings together. mysql

Re: [PHP] MySQL Problem with PHP

I understand about the concat function, but that doesn't really fit into my scheme of things I run all text for the web through a function SafeSQL so that values from the web don't make SQL error or potential hacks occur. All SafeSQL was doing (for mssql, access and just about any other db) was