Single Quotes Nightmare

Anon

OK,

I've tried every combination and method ... addslashes ($whatever) doesn't work in either a MySQL update statement or in an assignment statement ... what gives here ?
Any help is appreciated:

$howwasday = addslashes($howwasday);

$query = "UPDATE $usertable2 ".

"SET goal1 = '$goal1', ".
"goal1achieved = 'N', ".
"goal2 = '$goal2',".
"goal2achieved = 'N', ".
"goal3 = '$goal3',".
"goal3achieved = 'N', ".
"goal4 = '$goal4',".
"goal4achieved = 'N', ".
"goal5 = '$goal5',".
"goal5achieved = 'N', ".
"thankful1 = '$thankful1', ".
"thankful2 = '$thankful2', ".
"thankful3 = '$thankful3', ".
"thankful4 = '$thankful4', ".
"thankful5 = '$thankful5', ".
"howwasday = '".addslashes($howwasday)."' ".
"WHERE ID = $saveid and dateofgoals = '$todaysdate'";

The single quote is not being removed out of the howwasday field ....

Help !

mlb

Anon

adslashes() does not remove the single quotes, it just escapes them with backslashes (which is fine for MySQL, provided when you output you call stripslashes() that's why it's called addslashes() not removequotes().. If you really want to remove quotes completely, you'll need to preg them out your self)

Problem 1) You call addslashes() twice in the code you posted, you only really need to call it once (Unless you like pain, then call it as many times as you want)

Problem 2) use a printf() statement for the SQL query, it will make the code more readable and help you track down problems in SQL with greater ease

Problem 3) You don't give the error you're having. That goes a long way. If you're not cheking for errors oon your queries, you should be, they are helpful

Anon

This happened to me today while trying to use rawurlencode in my SQL statement, I actaully had to run the rawurlencode prior to printing the SQL statement. Something like $howsaday = addslashes($howsaday) somwehere before you start building your SQL statement.

Anon

Louie,

Thanks so much for your response ... I tried this as well and it didn't work ... Any other possibilities

Mike Buglioli