donno how to name... must see to recognise

[Naug]

Riddle me this:

$query="select locZ from creature where name='$this->name';";
$result=pg_exec($db, $query);
$row=pg_fetch_row($result,0);
print"<br>1.1|$row[0]|";
$query="update creature set dimension=$dimension+$disstance where id=$this->id;";
print"<br>$query";
pg_exec($db, $query);	
$query="select locZ from creature where name='$this->name';";
$result=pg_exec($db, $query);
$row=pg_fetch_row($result,0);
print"<br>1.2|$row[0]|";

gives me following output:

1.1|4|
update creature set locZ=locZ+1 where id=5047;
1.2|6|

now how come 4+1=6???

[mogster]

It's the obfuse and mysterious ways of php...no I'm kidding 😉 , but what if you tried to add $disstance to the previous picked $row[0] before updating?

Like:

$query="select locZ from creature where name='$this->name';";
$result=pg_exec($db, $query);
$row=pg_fetch_row($result,0);
print"<br>1.1|$row[0]|";
$dimUpd = $row[0] + $disstance;
$query="update creature set dimension=$dimUpd where id=$this->id;";
print"<br>$query";
pg_exec($db, $query);	
$query="select locZ from creature where name='$this->name';";
$result=pg_exec($db, $query);
$row=pg_fetch_row($result,0);
print"<br>1.2|$row[0]|";

knutm

[Naug]

that works.... but why didnt my version work? I mean thats cut and paste from the code there wasnt any code that could possibly change the value of locZ?

[mogster]

Erm.. I'm not that familiar with postgres, so I wouldn't know. But a guess would be ....or...perhaps...?

Ah, check this out:

$query="update creature set dimension=$dimension+$disstance where id=$this->id;";

would be changed to:

$query="update creature set dimension=dimension+$disstance where id=$this->id;";

See the diff? I think that may be the error in your original code: to set a db-field + something, the field must be adressed as itself - not as phpvalue 😉

knutm