updating a field in the same record

[hannesk]

I'm a newbie :(

I'm trying to update one field with the content of others.
with row updating - I have the following code:

function Row_Updating($rsold, &$rsnew) {
// Enter your code here
// To cancel, set return value to FALSE
$uu=$rsnew["id"];

$aa1=$rsnew["tanav"];
$aa2=$rsnew["majanr"];

$bb4=rtrim($aa1);
$bb5=rtrim($aa2);
$kokku="$bb4 $bb5";
$this->aadress_kokku->ViewValue=$kokku;
return TRUE; }

the field called "address_kokku" is not updated.

I tried with UPDATE SQL command, but as I'm updating - I don't get unique id from the table (id is auto increment field in mysql) and the value of id is constantly 0

Any suggestions?

[mobhar]

Change this:
$this->aadress_kokku->ViewValue=$kokku;

become:
$rsnew["aadress_kokku"] = $kokku;

[hannesk]

thanks Mobhar!

It works!