php and not saving right to the database

[eva21]

$string = "it''s blue";

 

$update = mysql_query("UPDATE node SET color = '" . $string . "' WHERE id = '" . $rows['id'] . "'");

 

but all i get is "it" when i try to echo it....why?

[MatthewJ]

Echo the query... it should be obvious then.. Just escape the apostorphe with a backslash instead... it is seeing the single quote as the close of the value

[Ken2k7]

You need to escape the single quotes or it will mess up the single quote in your SQL.

$string = "it''s blue";
$string = mysql_real_escape_string($string);
$update = mysql_query("UPDATE node SET color = '" . $string . "' WHERE id = '" . $rows['id'] . "'");

[eva21]

It keeps cutting off the word?

[wildteen88]

Where? In the databases or some other place. You need to be more specific.

[eva21]

In the database. It keeps cutting off the word.

[wildteen88]

How are you checking it in the database? Post the schema for your node table, maybe you have setup your color field incorrectly.

[eva21]

Im checking it in the actual database. I see its not saving correctly

[MatthewJ]

wow guys... echo the query... it returns

... 'it''s'... for that value... you can't escape a single quote, with a single quote, inside of single quotes.

 

Should make pretty good sense... change it to 'it\'s blue' and there shouldn't be a problem.