Page 1 of 1

problem with ' in a string of an update

Posted: Sun Aug 22, 2004 8:11 am
by pelegk2
i have this update :

Code: Select all

$SET=" Set_name='".addslashes($Set_name)."',
and the

Code: Select all

$Set_name= blabla'balvla
when i do this update i see in the db :
blabla''balvla
must i have this i the db?
if yes it means i need to use stripslashes all the time

Posted: Sun Aug 22, 2004 9:22 am
by feyd
yes...

Posted: Sun Aug 22, 2004 11:57 am
by McGruff

Posted: Sun Aug 22, 2004 11:24 pm
by Bill H
Bad link? "Error: http://www.pinkgoblin.com cannot be found."

Posted: Tue Aug 24, 2004 1:57 pm
by McGruff
Site must be down - hopefully it'll be back up soon.

Posted: Wed Aug 25, 2004 10:40 am
by hedge
what DB, I use Oracle and when I escape the quotes it has the smarts to store the data properly. example I quote it like this "bob''s cat can''t dance".

I can't believe any db would store the escape chars, that's hokey.