Problem updating row

[PhoenixDown]

I'm having a problem updating row in MySQL.

$query = mysql_query("update table set message='$what' where id='$id'", $connect);

 

[sleipnir214]

And?

Any errors?

Any strange behavior? ______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[PhoenixDown]

I made a commenting thing for my guestbook, but it only adds SOME comments:

$query = mysql_query("select message from table where id='$id'", $dbi);
list($message) = sql_fetch_row($query, $connect);

$what = &quot;$message<br><br>Comment by $admin[0]: $the_comment&quot;;

$query = mysql_query(&quot;update table set message='$what' where id='$id'&quot;,$connect);

 

[sleipnir214]

What do you mean? Give me an example of a comment it will not add.

Does the comment have apostrophes or other mysql-sensitive data in it? If you, you might try running the user-supplied comment through mysql_escape_string() first. ______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[PhoenixDown]

An example comment would be:

message = Hi Cal, I sent a report to U. Enjoy...

I printed the query and this is what I got:

mysql_query(&quot;update table set message='Original message<br><br>Comment by Calvin: test' where id='40'&quot;,Resource id #1);

It still doesn't update it.

 

[sleipnir214]

What error are you getting?

What does mysql_error() say? ______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[PhoenixDown]

It doesn't say anything.


$query = mysql_query(&quot;select message from table where id='$id'&quot;, $dbi);
list($message) = sql_fetch_row($query, $connect);

$what = &quot;$message<br><br>Comment by $admin[0]: $the_comment&quot;;

$query = mysql_query(&quot;update table set message='$what' where id='$id'&quot;,$connect);
mysql_error($query);

 

[sleipnir214]

Try &quot;print mysql_error ();&quot; ______________________________________________________________________
Never forget that we are
made of the stuff of stars

 

[PhoenixDown]

Thanks, sleipnir214! I owe you one!

It's the ''s and &quot;'s that are in some of the entries that are causing the problem. I fixed it for those characters.

 

[sleipnir214]

It's the apostrophes that are the source of a high percentage of data-driven SQL errors. ______________________________________________________________________
Never forget that we are
made of the stuff of stars