Hi,
I am using rules module to set a trigger for an action with "Execute Custom PHP code" My code
db_query("UPDATE content_type_bunit,content_type_town SET content_type_bunit.field_bunit_supposed_quantity_value=content_type_bunit.field_buint_family_members_value * '%d',content_type_bunit.field_bunit_test_contract_value='%d',content_type_bunit.field_bunit_percentage_value ='%d' where content_type_bunit.field_town_id_org_value='%d' and content_type_town.field_town_id_value='%d'",$node->field_percentage[0]['value'],$node->field_contract_id[0]['nid'],$node->field_percentage[0]['value'],$node->field_town_id[0]['value'],$node->field_town_id[0]['value']);
was working fine and update the datas in the database. But the problem is i cant view the updated datas in the text field, it shows the old datas only, So Could anyone help me to sort out the problem...