Adding Strings with quote's in?
kpielorz at tdx.co.uk
Fri Feb 11 13:24:15 EST 2000
OK - We've now got PHP + FreeTDS + SQL V7 to talk quite nicely to each
other... The problem I'm stuck with now is how to insert the following text
into a database field...
The Wolve's are coming
INSERT INTO test VALUES( 'The Wolve's are coming' );
Isn't going to cut it, so I used PHP's "AddSlashes" function, which does the
INSERT INTO test VALUES( 'The Wolve\'s are coming' );
Which it doesn't seem to like either...
Any suggestions? - Is there a problem doing this with FreeTDS? (We have
another system running MySQL which I do manage to use AddSlashes to protect
embedded quotes etc. in field data with)...
More information about the FreeTDS