Update problem in MySQL

[Cadish]

Hi,

I have to update something in my database. The text I want to update looks like this:

Code Select Expand

    <table cellpadding="0" cellspacing="0" width="100%">
     <tr align="center">
      <td>19&deg;C</td>
      <td>19&deg;C</td>
      <td>19&deg;C</td>
     </tr>
    </table>

The query to update the database looks like this:

Code Select Expand

db_query("
UPDATE {$db_prefix}mod
SET text = " . $string . "
WHERE id = $id
LIMIT 1", __FILE__, __LINE__);

Why is it giving me an error everytime I want to run the script? What's wrong?
I've tried to encode the $string with htmlspecialchars($string) and more things like this, but nothing helps...

Any help appreciated
Cadish

[[Unknown]]

SET text = '$string'

-[Unknown]

[Cadish]

Why do I feel like a stupid fool??

Thanks dude!