sugar contact module update

[aljassi]

hello everyone,

i want to make an update in the contact module of sugarcrm but i dont know how it really works.
can you help me.

hier is my query for the update

$server="http://server/sugarcrm/soap.php";
// include_once WP_PLUGIN_DIR . '/wp-sugarcrm-api-soap/sugarsoapclient.php';
..
// code

$updateQuery = "contacts.id in ( UPDATE eabr.bean_id SET webtolead_email1='".$email."', primary_address_street='".$street."', primary_address_postalcode='".$postalcode."',prima ry_address_city='".$city."' WHERE last_name='".$contact['last_name']."' AND first_name='".$contact['first_name']."')";
$updateSoapClient = new sugarSOAPclient( $server );
$UpdateResult=$updateSoapClient->login( $user_name, $user_password , false );
$contact_email = $username;
$contact_password = $password;
//$contactsUpdate= $updateSoapClient->setEntryList( 'Contacts', $updateQuery, '', 0, '', 1 );
$contactUpdates= $updateSoapClient->getEntryList( 'Contacts', $updateQuery, '', 0, '', 1 );


if ($contactUpdates['result_count'] == 1){
// Convert SugarCRM's name_value_list to an associative array
$contactUpdate = convertNVLToArray( $contactUpdates['entry_list']['0']['name_value_list']);

}
$updateSoapClient->logout();
}


the code does not work and i spent a lot of time but i cant fix the problem
can someone help me?

[eggsurplus]

Not exactly sure why you need soap here but I see you trying to run an Update from within an IN clause which shouldn't work. You may want to try something similar (not tested) to:

 global $db;
$updateQuery = " UPDATE eabr.bean_id SET webtolead_email1='".$email."', primary_address_street='".$street."', primary_address_postalcode='".$postalcode."',prima ry_address_city='".$city."' WHERE last_name='".$contact['last_name']."' AND first_name='".$contact['first_name']."'";
$db->query($updateQuery); 
  

[aljassi]

hi,

do you know another way to do that without using soap?