MySQL Forums
Forum List  »  New in 4.1: Subqueries

problem with escape characters
Posted by: sonu
Date: February 08, 2005 09:55AM

i have a form from where i am inserting values like hhdj's 1'st and inserting into table first time MSQL automaticall takes escape characters before those single quotes and furter in my application i need to pick values from that table and insert into another table that time mysql doesnt take escape characters so query gives error whats the solution to this problem. i tried replace() but how to use it i mean
query="insert into members(address) Values(replace('$row[address]',',\'))"; this is what i want to do is replace single quote with \' so that when i try to insert my string again mysql reads it as escape character.

Options: ReplyQuote


Subject
Views
Written By
Posted
problem with escape characters
7390
February 08, 2005 09:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.