Assistance with array

Hi Ross,

The list array below in bold, I need it to list all accounts where the user has the field adjusts_third_party_claims check-marked in addition to those that match the $CURRENT_USER['member_company_accounts']

$accountsRecordsByMemberCompany = array_groupBy($accountsRecords, 'member_company_accounts', true);
$currentUserMemberCompany       = @$accountsRecordsByMemberCompany[$CURRENT_USER['member_company_accounts']];

Thanks - NMSINC

Hi there.

Thanks for hanging on!

What I'm thinking for this array is that we actually look at it at the MySQL level. How about something like this when you are loading the account records:

 // load records from 'accounts'
 list($accountsRecords, $accountsMetaData) = getRecords(array(
   'tableName'   => 'accounts',
   'loadUploads' => true,
   'allowSearch' => false,
   'where'       => "adjusts_third_party_claims = '1' AND field_name = '". mysql_real_escape_string($CURRENT_USER['member_company_accounts'])  ."'",
 ));

The only thing is that I don't see in your description which field $CURRENT_USER['member_company_accounts'] needs to compare to in the accounts record so you'll see in my code where I used "field_name ".  You'll need to swap in the appropriate field.

Once you have that setup though, you'll have $accountsRecords setup right off the bat and there's no fussing about with combining arrays.  Let me know what you think.

Thanks!

Thanks for the help Ross!

You're welcome! Let me know if it gets things going for you or not :)