Edits a record in a table.
int db_edit_record(string tablename, int id [, mixed fieldnames [, mixed fieldvalues [, string idfield]]])
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 |
The result will be the actual id or FALSE, if the record could not be edited.
// 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 ");