[development] correct way to update/insert a value in a table

31 Mar 2008

      I need to save a value inside a table; I think the best/fast way of doing so is:

    if (!db_query("INSERT INTO {wu_options} (vid, nid, name, value)
                   VALUES (%d, %d, '%s', '%s')",
                   $node->vid, $node->nid, $key, $value))
        db_query("UPDATE {wu_options} SET value = '%s'
                     WHERE vid = %d AND nid = %d AND name LIKE '%s'",
                     $value, $node->vid, $node->nid, $key);

but despite it works, it display an error. Is there any way of hidding
a database error (similar to "@any_function(...) in PHP)? Or any other
way to make drupal try to update a value, and if it don't exists,
create it?

thanks

-- 
*Envellim quan els records superen les esperances.
*Als llocs desconeguts només s'hi arriba per camins desconeguts.

[development] correct way to update/insert a value in a table

Lluís