php mssql single quotes problem

[Anon]

<pre>
I have a problem inserting the following via php page...
insert into table1(message1)
values("this is nicki's test")

it always inserts "this is nicki\'s test"

this above has a backslash before the single quote(i don't know if that will come out).

i have also tried replacing the single quotes with a back quote and that too gets a backslash in the table. can anyone help?

here's code:

$submitted_message=eregi_replace("\'","`",$submitted_message);

UPDATE TABLE set
message=\"$submitted_message\"
where id=$picked_id";
$result7 = MSSQL_QUERY($query7);

</pre>

thanks!!

[cordex]

Magic quotes is on so this is done automatically. It can be very irritating.
On the other hand, it can be handy to keep your script from dumping out DB errors. Just run stripslashes() on the items you pull back out of the table.

[Anon]

great! this is perfect. it worked on inserting into the tables as well- as long as you use double quotes on the outside.

i usually turn errors off and just try to think of all possible errors (laugh) anyway.