The sql_updateq() function is used to update content in an SQL table. The content passed to the function is automatically filtered.
Its 6 arguments are the same as for sql_update():
-
$table is the SQL table in question, -
$exp contains the modifications to be made, -
$where, -
$desc, -
$serveur, -
$option.
It is used as shown below:
sql_updateq
('table', array('column' => $value), 'id_table=' . intval($id_table));
Example
The modifier_contenu() function in ecrire/inc/modifier.php is called when an editorial object is modified, and takes care of calling the pre_edition and post_edition pipelines, using the sql_updateq() function to update the collected data:
sql_updateq($spip_table_objet, $champs, "$id_table_objet=$id", $serveur);