Insert double cotation record

alirezaok

hi
i want to insert or update a record to mysql.
content of text filed has some " character (they are html codes: <table dir="ltr" .... >)
when i want to add normal it doesn't work

$sqlquery = "INSERT INTO static VALUES('$content')";
$results = mysql_query($sqlquery);

but when i use of $content=addslashes($content); before this code it works success but when i view the content of record before all " characters there is \ character ( all " converted to \") (<table dir=\"ltr\" ... )

mysql_real_escape_string() works like addslashes() too

i dont want add anything before " characters when i view record.

what do i do?

halojoy

maybe you should try
this with MySQL data before you output to display
http://php.net/stripslashes

it is the opposite to addslashes

alirezaok

yes but still there is \" in database

halojoy

alirezaok wrote:
yes but still there is \" in database

It should be!
When storing data with quote ( " ) in MySQL we have to add slashes.
Otherwise database will make error.

Then when we use data, we remove slashes for output.

bogu

$sqlquery = "INSERT INTO static VALUES('".mysql_real_escape_string($content)."')";