Escaping Quotes

Ok guys, here for some help again With MySql if you have a form, you can escape the quotes by using the command mysql_real_escape_string. The problem is, I have MS SQL and not My Sql. This command does not work on MSSql and I can't figure out how to escape the quotes, so that I can post quotes in the database. Can somebody help?

Thanks,
Jordon

Have your tried mssql_real_escape_string()?

If that doesn't work try addslashes();

Actually mssql_real_escape_string() did not work. That's what I tried at first. I spent several hours working this last night; however, in the end, I found something that would work:



Basically stripslashes wouldn't work on it own. After research the only thing MSSQL has a issue with is ' and if you double it, by using '' then it will comment it out. So, that's why I used a string replace from ' to ''; however, when I did this, it posted in the Database like jordon\'s and I could not get rid of the slash, unless I used stripslashes, so as you see, that's how I came up with this line of code, which seems to be working great!

alright, cool. Glad you got it figured out.