Compare Arrays

drophit

OK lets try that again:

How could i compare these two arrays in order to create a new array:

Array One

Posted_Apps Array
(
[0] => Array
(
[lender_id] => 1
[app_count] => 2
)

[1] => Array
(
[lender_id] => 3
[app_count] => 4
)

)

Array 2

Eligible_LendersArray
(
[0] => Array
(
[lender_id] => 3
[daily_max] => 100
)

[1] => Array
(
[lender_id] => 5
[daily_max] => 100
)

[2] => Array
(
[lender_id] => 4
[daily_max] => 100
)

)

I want the comparison to be such that each instance of lender_id in array one is compared to the matching instance in the second array regarding the daily_max value and create a new array of eligible lender_ids for those that are equal or LESS than the daily max of array two.

i.e.

New_array

(
[0] => 3
[1] => 5
[2] => 4
)

The new array should show all lenders who have daily_max LESS THAN or EQUAL TO app_count.

wilku

It would be a lot easier if you construct your arrays like
Array(lender_id=>value)
Then simple array elements accesing would be sufficient:

$new = array();
foreach( $PostedApps as $lender=>$today)
{
  if ($today < $Eligible_lenders[$lender]) $new[]=$lender;
}

Otherwise you need to have two loops

foreach( $PostedApps as $larr)
{
  foreach($Eligible_lenders as $earr)
  {
    if ($larr['lender_id']==$earr['lender_id'] && $larr['app_count'] < $earr['daily_max'])
    {
      $new[]=$larr['lender_id'];
      break;
    }
  }
}

Haven't checked if it works.

drophit

OK will try it but i am using multi-d array because th can not figure out how to create ana ssoc array from mysql and actually create the array with more than one entry heres what i have:

while ($row2 = mysql_fetch_array($result2))
{
$active_lenders = array("".$row2['cc_lender_id']."" => "".$row2['daily_max']."");

session_register ("active_lenders");

But this only returns one row, how would i make it return all rows, as right now it is simply showing the lastone!

wilku

Try this:

while ($row2 = mysql_fetch_array($result2)) 
        { 
	$active_lenders[$row2['cc_lender_id']] =$row2['daily_max'];

    } 
session_register ("active_lenders");

drophit

Yeah your first code, the one with 2 loops, does the same thing $new is not populating with anything more than the last result making it a single variable array.

drophit

OK the while code worked! Getting right array now, lemme try the single looper.

drophit

Ok well i got the first arrays to store the values correctly:

Array - all_active_lenders
(
[3] => 100
[5] => 100
[4] => 100
)
Array posted_apps
(
[1] => 2
[3] => 5
)

with the arrays above heres what the results should loook like:

Array - new_active_lenders
(
[0] => 3
[1] => 5
[2] => 4
)

ONLY lender ids from the first array should be listed and ONLY those ids where the values in the second array are greater than or equal to the values in the first array. Even if lender 1 is listed in posted-apps, he should not appear in new_active_lenders since he is not present in the active_lenders array. AND, vice-versa for lender 3, he SHOULD appear since he is automatically less than since he does not appear in posted_apps.

wilku

OK I've misunderstood your problem a little. Here's the solution:

<?php
$PostedApps = array(1=>2, 3=>100);
$Eligible_lenders = array(3=>100, 5=>100, 4=>100);
$new = array();
foreach( $Eligible_lenders as $lender=>$max)
{
  if (!isset($PostedApps[$lender]) || $max > $PostedApps[$lender]) $new[]=$lender;
}
echo "Posted:";
print_r($PostedApps);
echo "<br>Limit:";
print_r($Eligible_lenders);
echo "<br>Everyone below limit:";
print_r($new);
?>

drophit

I am getting this output:

Posted:Array ( [1] => 2 [3] => 5 )
Limit:Array ( [3] => 100 [5] => 100 [4] => 100 )
Everyone below limit:Array

Nothing showing in Everyone?

drophit

OK got it thx!!!!

drophit

Ehh well it kinda works, i mean it dont exclude data if it is over the max values. SHould only include lenders from eligible if they are under or equal to the 100, but it includes them all

drophit

I dunno i tried changing it i dont understandi tso...