pquery($query, array()); for($i=0;$ipquery('select * from vtiger_users where user_name=?', array($_REQUEST['assigned_user_id'])); $changevalue=$adb->query_result($resultset,0,"id"); $changekey='assigned_user_id'; } $sql="update vtiger_troubletickets set $changekey = ? where id = ?"; $adb->pquery($sql, array($changevalue, $id)); } header("Location: index.php?action=index&module=HelpDesk"); ?>