Anyone one around who is good with Arrays???

[jollyguy4all]

Hi,

I have a query which generates an array from the database results returened:

$getrel = mssql_query('select * from products where vendor_code=151');
while($gotrel = mssql_fetch_array($getrel))
{
$relation[$gotrel[id]] = array ('id' => $gotrel[id],
'rvccode' => $gotrel[vendor_ccode],
'rvsname' => $gotrel[vendor_sname],
'rpcat' => $gotrel[prod_cat],
'rpnm' => $gotrel[prod_nm],
'rused' => '0');
}

Now I go through this array in steps and first want to identify all products with prod_cat="Hardware" and set their 'rused' element to '1'

$fld1 = 'rpcat';
while (list ($key, $val) = each ($relation)){
if ($relation[$key][$fld1] == 'Hardware') { $relation[$key]['rused'] = '1';
}
}

The code does go into the loop but does not update the element in original array $relation but instead creates a new array instead. Can anyone let me know how to update the array element in the original array.

Thanks

[bbreslauer]

Are you doing this inside of two separate functions? Because, if you are, you'll need to make sure that you are passing the array by reference (in the argument list, preceed the $ with a &, meaning it would become &$array). This is the only way I can think of that would create another array to work on.

[jollyguy4all]

Thanks for the prompt reply.

Actually my code flow is as follows:

//GATHER VALUES//
$treetxt = '';
$treeroot = '';
$getrel = mssql_query('select * from product_rev_det where vendor_ccode=151 and yr=2005 and status=1 order by ref_ctype, ref_ccode');
while($gotrel = mssql_fetch_array($getrel))
{
$relation[$gotrel[id]] = array ('id' => $gotrel[id],
'rccode' => $gotrel[ccode],
'rccode_rel' => $gotrel[ccode_relation],
'rvccode' => $gotrel[vendor_ccode],
'rvsname' => $gotrel[vendor_sname],
'rpmainid' => $gotrel[prod_mainid],
'rpcat' => $gotrel[prod_cat],
'rpnm' => $gotrel[prod_nm],
'rrccode' => $gotrel[ref_ccode],
'rrcname' => $gotrel[ref_cname],
'rrctype' => $gotrel[ref_ctype],
'rrevpcent' => $gotrel[rev_pcent],
'rused' => '0');
}

function findDistributor($arr, $fld1, $val1)
{
while (list ($key, $val) = each ($arr)){
if ($arr[$key][$fld1] == $val1) {
$target[$key] = $arr[$key];
$relation[$key]['rused'] = '1';
}
}
return $target;
}

Now in this code you can see that I am generating the relation array in the main page which contains a function. I pass the array to a array variable in the function but within the function i use the same name $relation which was declared outside to update the element of the array generated previously.

[Weedpacket]

No, PHP's scoping rules don't work like that. You want to pass the array by reference.

[jollyguy4all]

Thanks for your comments guys. Yes, it was a scope problem, have corrected it now by passing the array by reference to my function.

Thanks once again.