## db_edit_record

int db_edit_record (string tablename, int id [, mixed fieldnames [, mixed fieldvalues [, string idfield]]])

Edits a record in a table.

Arguments

tablename is the name of the table that will be affected.
id is the id number of the record to be edited.
fieldnames is a set of identifiers that may be an array or a CSV string (without the "id" field).
fieldvalues is a string with the values of the records desired. It may be an array or a CSV string.
idfield is the name of identifier field (column). Default is "id" .

Result

The result will be the actual id or FALSE, if the record could not be edited.

Keys and columns

The table below summarizes the options for fieldnames and fieldvalues.

fieldnames | fieldvalues | Data inserted
--- | --- | ---
null | null | a record with all fields "0"
null | string array | a record with all fields with their fieldvalues
string array | string array | a record with fieldnames with their fieldvalues

Example

`// Edit value of "name" in 3. record in mytable $fn = "name"); $fv = "shed"; $res = db_edit_record("mytable",3, $fn, $fv); echo ("id is $res ");`

See also

Database functions
Database support