This topic is locked

Updating Multiple Table Event

8/31/2009 5:27:23 AM
PHPRunner General questions
M
Mandy author

Hi.

Excuse my ignorance but....

I am using this event:*uopdate multiple tables)


global $conn;
$sql = "update othertable set joinedfield=".$values["joinedfield"]." where othertable_id".$values["othertable_id"];
db_exec($sql,$conn);
unset($values["joinedfield"]);


How do I change this query to update another field (ie. joinedfield2), also where othertable_id".$values["othertable_id"];
I tried a few things, all with out success.

Thank you in advance.

Mandy