[development] correct way to update/insert a value in a table
Lluís
enboig at gmail.com
Mon Mar 31 12:43:48 UTC 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.
More information about the development
mailing list